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

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

update a sum between two tables in ado vb6

Show all headers | View raw

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

Back to microsoft.public.sqlserver.programming | Previous | Next — 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