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

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

Re: update a sum between two tables in ado vb6

Show all headers | View raw

 (csvanderwerf@gmail.com) writes:
> 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
> 

If we overlook that this forum/newsgroup is dead, the scope for this
newsgroup is SQL Server, and you talk about Access. I would recommend 
that you find an Access forum to answer the question. While both SQL Server
and Access use SQL, there are considerable differences between the two.


-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

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