| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
I'm not sure why DSum() is used when it looks like a simple control source
of =Amount-Amount2 should work the same. -- Duane Hookom MS Access MVP "Marshall Barton" <(E-Mail Removed)> wrote in message news  (E-Mail Removed)...> Alan wrote: > >>=DSum("[Amount]"-"[Amount2]","Tabel1"," [CustomerNo] = " & [CustomerNo]) >> >> >>Have this on my report >> >>my report fives me this >> >>CustomerNo Amount Amount2 result >> >>C00001 1000 1000 #error >>C00002 1000 2000 #error > > > You have the quotes around the names instead of around the > expression. Try it this way: > > =DSum("Amount-Amount2","Tabel1","CustomerNo =" & CustomerNo) > > All those [ ] were unnecessary so I removed them. > -- > Marsh > MVP [MS Access] |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dlook & DSum in Report and groups by Report Groupings | gumby | Microsoft Access Reports | 1 | 18th Feb 2007 01:24 PM |
| Dsum on a report | =?Utf-8?B?bmV2cG9l?= | Microsoft Access | 8 | 29th Jan 2007 09:26 PM |
| DSUM Report | =?Utf-8?B?UmF5IFRvZGQgSnI=?= | Microsoft Access Reports | 3 | 21st Nov 2005 09:48 PM |
| DSum in a report | =?Utf-8?B?bmVlbm1hcmll?= | Microsoft Access Reports | 0 | 28th Apr 2005 03:38 PM |
| DSum in Report | =?Utf-8?B?bmVlbm1hcmll?= | Microsoft Access Reports | 7 | 9th Apr 2005 10:19 PM |
