Groups > microsoft.public.sqlserver.programming > #31325

Re: update a sum between two tables in ado vb6

X-Received	by 10.31.155.209 with SMTP id d200mr1455702vke.16.1501855087349; Fri, 04 Aug 2017 06:58:07 -0700 (PDT)
X-Received	by 10.31.148.19 with SMTP id w19mr10161vkd.17.1501855087276; Fri, 04 Aug 2017 06:58:07 -0700 (PDT)
Path	csiph.com!3.us.feeder.erje.net!feeder.erje.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!s6no459278qtc.1!news-out.google.com!e5ni331qta.0!nntp.google.com!w51no459547qtc.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	microsoft.public.sqlserver.programming
Date	Fri, 4 Aug 2017 06:58:07 -0700 (PDT)
In-Reply-To	<c2c972fe-1839-44eb-a99f-20f48a608072@googlegroups.com>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=2a02:a442:a0b9:1:8d7f:61a:c3bb:7dce; posting-account=8gItnwoAAACAGpIskc7O4at4fMTjeHrv
NNTP-Posting-Host	2a02:a442:a0b9:1:8d7f:61a:c3bb:7dce
References	<c2c972fe-1839-44eb-a99f-20f48a608072@googlegroups.com>
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<7427677f-4e3d-4a5e-9704-9ddc1e26497b@googlegroups.com> (permalink)
Subject	Re: update a sum between two tables in ado vb6
From	csvanderwerf@gmail.com
Injection-Date	Fri, 04 Aug 2017 13:58:07 +0000
Content-Type	text/plain; charset="UTF-8"
Lines	21
Xref	csiph.com microsoft.public.sqlserver.programming:31325

Show key headers only | View raw

Op vrijdag 4 augustus 2017 15:42:52 UTC+2 schreef csvand...@gmail.com:
> Hello my friends
> 
> I am building an account-program, for that:
> 
> I want to update a field in an access table. 
> The field should add the value in tableR.bedrag 
> with the sum in tabelb.bedrag in a certain periode
> A bit like this:
> 
> Update TableB set Bedrag = TableR.Bedrag + SUm(tableB.bedrag) where datum between fromdate and todate.
> 
> where TabelR.bedrag is the value from a previous periode, written in tabelR
> 
> Any Idea?
> 
> Thanks in advance
> 
> Catharinus

And I forgot something to mention:
The Two tables are joins via the field tabelr.reken and tabelb.reken

Back to microsoft.public.sqlserver.programming | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

update a sum between two tables in ado vb6 csvanderwerf@gmail.com - 2017-08-04 06:42 -0700
  Re: update a sum between two tables in ado vb6 csvanderwerf@gmail.com - 2017-08-04 06:58 -0700
  Re: update a sum between two tables in ado vb6 Erland Sommarskog <esquel@sommarskog.se> - 2017-08-04 21:19 +0200

csiph-web