Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.programming > #31326
| 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 <esquel@sommarskog.se> |
| 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 | <XnsA7C7D8E498298Yazorman@127.0.0.1> (permalink) |
| References | <c2c972fe-1839-44eb-a99f-20f48a608072@googlegroups.com> |
| 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 |
Show key headers only | 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
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