Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > microsoft.public.sqlserver.programming > #31324
| X-Received | by 10.98.21.82 with SMTP id 79mr1489758pfv.47.1501854166776; Fri, 04 Aug 2017 06:42:46 -0700 (PDT) |
|---|---|
| X-Received | by 10.31.167.5 with SMTP id q5mr9681vke.12.1501854166474; Fri, 04 Aug 2017 06:42:46 -0700 (PDT) |
| Path | csiph.com!feeder.erje.net!2.us.feeder.erje.net!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!u14no390774ita.0!news-out.google.com!e5ni333qta.0!nntp.google.com!s6no457034qtc.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail |
| Newsgroups | microsoft.public.sqlserver.programming |
| Date | Fri, 4 Aug 2017 06:42:46 -0700 (PDT) |
| Complaints-To | groups-abuse@google.com |
| Injection-Info | glegroupsg2000goo.googlegroups.com; posting-host=2a02:a442:a0b9:1:8d7f:61a:c3bb:7dce; posting-account=8gItnwoAAACAGpIskc7O4at4fMTjeHrv |
| NNTP-Posting-Host | 2a02:a442:a0b9:1:8d7f:61a:c3bb:7dce |
| User-Agent | G2/1.0 |
| MIME-Version | 1.0 |
| Message-ID | <c2c972fe-1839-44eb-a99f-20f48a608072@googlegroups.com> (permalink) |
| Subject | update a sum between two tables in ado vb6 |
| From | csvanderwerf@gmail.com |
| Injection-Date | Fri, 04 Aug 2017 13:42:46 +0000 |
| Content-Type | text/plain; charset="UTF-8" |
| Lines | 17 |
| Xref | csiph.com microsoft.public.sqlserver.programming:31324 |
Show key headers only | 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
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