dsum on report getting #error

=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

Please can some tell me why i'm getting error??

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]

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" wrote in message
news
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]

Duane Hookom wrote:

I'm not sure why DSum() is used when it looks like a simple control source
of
=Amount-Amount2
should work the same.


Well, Duane, you raise a very good point. I think I may
have been in too big a hurry to answer the question that was
asked and skipped right on by the real situation.

--
Marsh
MVP [MS Access]