Newbie: Displaying a Count() of Filtered recordset

[Brian Beam]

I apologize in advance if this question is too rudimentary, or has been
asked before...

I have a report that displays a recordset produced by the Filter by Form
option. I would like to display a count of the records in the recordset, but
am unsure how to do it.

I have tried creating a text box in the report's footer with
=Count([Filter]), but it produces an #Error.

I would appreciate any hints you can give me. (BTW, the report is bound to a
query.)

Thanks,

Brian

 

[Marshall Barton]

I have a report that displays a recordset produced by the Filter by Form
option. I would like to display a count of the records in the recordset, but
am unsure how to do it.

Ordinarily, you would just use

=Count(*)

The * has a special meaning for Count where it maens all the
records.

 

[Brian Beam]

Thanks for the quick reply. I tried that and am still getting an #Error.

 

[Brian Beam]

Figured out the problem with Duane H.'s help... The problem was I had the
text box in the Page Footer instead of the Report Footer.

Thanks again for your assistance.

Brian