Newbie: Displaying a Count() of Filtered recordset

  • Thread starter Thread starter Brian Beam
  • Start date Start date
B

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
 
Brian said:
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.
Click to expand...

Ordinarily, you would just use

=Count(*)

The * has a special meaning for Count where it maens all the
records.
 
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
 
Back
Top