Count number of records on each page of a report

[energizer68usa]

I have a small database (approx 130 records). The records are grouped by levels 1, 2, 3, etc. I created a report that shows each group of records on one page. Level 1 has 21 records, Level 2 has 16 records, etc. However, when I put in the "count" formula in the page footer, it consistently comes back with the same number of records per page (i.e., 24) no matter how many are really on the page. What am I doing wrong?
Thanks for any assistance you can offer.

 

[SydneyGeek]

It's hard to do on a page because the Page Footer is useless for calculated fields -- for some reason they either return errors or incorrect values. You can, however, count records in a group by putting a custom TextBox in a group header or footer. Here's how:
1. Create an unbound TextBox. Make its ControlSource "=1" (without the quotes), and place in a group header or footer.
2. Set the RunningSum property to Over Group.

Modification: If you want each record numbered, place the same TextBox in the Detail section.

Denis

 

[CT Witter]

Check out MS KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;216311&Product=acc2000 - How to Create Page Totals on a Report

HTH,
CT