A Simple DCount Tbo . . . hopefully!

[mseeker22]

See attached screenshot -

I'm trying to get the Tbo labelled '10% Total:' to add up the number of times '10%' appears in the table on the subform named 'F_RCUsage'.

I'm currently placing the following code into the Control Source of '10% Total' Tbo:

=DCount("[Discount Amount]","Q_RCUsage","[Discount Amount=10%]")

I'm hoping its just a simple syntax error that I don't seem to be able to get right.

Thanks in advance!

[pbaldy]

With the whole bit in brackets, Access is interpreting that as a field name. I'd expect something like:

=DCount("*","Q_RCUsage","[Discount Amount]=10%")

or

=DCount("*","Q_RCUsage","[Discount Amount]=.1")