showing COUNT in a subreport

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Richardson - 01 Dec 2005 22:30 GMT

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.

Reply to this Message

Allen Browne - 02 Dec 2005 01:38 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message

Bob Richardson - 02 Dec 2005 23:23 GMT

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

> Open your subreport in design view.
>
[quoted text clipped - 9 lines]
>> in the subreport...preferable at the bottom of the list although it would
>> be ok to print it up in the main report.

Reply to this Message