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?

[ansentry]

In an unbound text box in the header put:

=Count([Client])

That is assuming that the control "Client" will never be null.


Regards,

John A

[thhui]

Just put a textbox in the form's header

and set its control source equal to

 
=Count(*)