Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: update a sum between two tables in ado vb6

Show all headers | 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