Counting records of a parameter query

[JonathanT]

I have a report based on a parameter query and I want to count the records returned by the query.

I am using a calculated field in the report header to count the number of records returned. The query works fine every time. I always get a #error every time in the calculated field on the report. Here's what I've tried in the calculated field.

resnumber is the field to count
breakfast is the query name

=dcount("[resnumber]","breakfast")
=dcount("[resnumber]","[breakfast]")


=count(*)

Any help would be appreciated. The report and query can be redesigned completey if necessary

[RuralGuy]

A Report has a RecordSource and that RecordSource has a Me.Recordset.RecordCount

[JonathanT]

I'm sorry, I'm still not clear on this.

My report has a recordsource which is the paramter query.

How do I utilize the Me.Recordset.RecordCount?

[RuralGuy]

Use it instead of the DCount() you were trying.

[JonathanT]

Problem solved. I had my control in the page header instead of the report header. I ended up using =count(*) as the control source in my text box. I also used another text box in the detail section with =1 as the Control Source and Over All as the running sum to give me a running count.

[RuralGuy]

Great! Thanks for posting back with your success and solution.