Should be simple DSUM - I get #error

[crimedog]

1. I know the value in the query is not blank


2. Assume the names are correct

I have

=DSum("[SumOfRepRevenue]","QuryCOMMRepDealsM1Mgr","[LastOfClassification]=6")

I have tried using bracket on the Domain also...
In the query there is one line with LastOfClassification = 6 the SumOfRepRevenue = 14000
the DSum returns #Error in the Text box.

Don't know what I am missing...

[John_G]

The error might not be in the Dsum.

Where are you using the expression, i.e. in what property of the text box?

Did you try the DSUM in the immediate window (Ctrl-G) to see if it is returning the correct value?

Is the table field that is behind the query field [LastofClassification] (I assume it is [Classification]) numeric or text type?

[JamesDeckert]

=DSum("[SumOfRepRevenue]","QuryCOMMRepDealsM1Mgr","[LastOfClassification]=6")

if [LastOfClassification] is text
DSum("[SumOfRepRevenue]","QuryCOMMRepDealsM1Mgr","[LastOfClassification]='6'"
if numeric
DSum("[SumOfRepRevenue]","QuryCOMMRepDealsM1Mgr","[LastOfClassification]=" & 6
I also don't think you should be using the "=" which is used in Excel, but can't remember a place it's used in Access.

[crimedog]

You guys were right - the table had it in Text - so surrounding it with single quote fixed it.

Thanks!