Path: csiph.com!feeder.erje.net!2.eu.feeder.erje.net!border1.nntp.ams1.giganews.com!nntp.giganews.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: microsoft.public.sqlserver.programming Subject: Re: update a sum between two tables in ado vb6 Date: Fri, 04 Aug 2017 21:19:17 +0200 Organization: Erland Sommarskog Lines: 23 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx02.eternal-september.org; posting-host="312b684dfae83d150521b3e54c9d8068"; logging-data="821"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18wezNTbGati1WVpMqHxh40" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:0m6fiXGfaFibK1+i/FiUP2HEJD8= Xref: csiph.com microsoft.public.sqlserver.programming:31326 (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