showing COUNT in a subreport

  • Thread starter Thread starter Bob Richardson
  • Start date Start date
B

Bob Richardson

In my sub report I just list names of people, in two columns. I use the
zigzag approach because I can't seem to get the down and up approach to work
(Access 2003). My question is, how can I print the number of people in the
subreport...preferable at the bottom of the list although it would be ok to
print it up in the main report.
 
Open your subreport in design view.

If you do not see a Report Footer section (grey bar) near the bottom of the
report, click Report Header/Footer on the View menu.

In the Report Footer section, add a text box with this Control Source:
=Count("*")
 
Thanks a lot Allan. I had my count statement in the Page Footer, not the
Report header.
 
Back
Top