Dcount on report

[mattbrem]

I have a report based on a query that requests two dates as criteria, start and end. THe query pulles records from my table that fall between those two dates.

In my page header I have a textbox that I would like to count the number of records pulled by the query, but I don't want all of the records counted, just those matching another criteria, the control source for the text box is

DCount("[Client]","QueryComplianceWeekly","[Subprocess] = 'Insufficiency Resolution' ")


I have tried to use DCount to do this but I keep getting Error# as the result. Can anyone point me in the right direction for the correct syntax to do this?

 

[pbaldy]

Do you have the required "=" at the beginning? That and the space at the end are the only issues I see right off.