showing COUNT in a subreport

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.
 
A

Allen Browne

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("*")
 
B

Bob Richardson

Thanks a lot Allan. I had my count statement in the Page Footer, not the
Report header.
 
Top