Page numbering in Reports

[Guest]

I have a report setup that will print activity information for my staff with
totals at the base of their last page. Since some employee's reports may be
1 page others may have 3 to 5 pages. I'd like to number the pages for each
employee. So instead of it showing 'Page 1 of 375' (etc), I need this report
to display 'Page 1 of 2' or 'Page 1 of 5' so that it numbers the pages based
on how many pages that respective employees report is.

How can I do this?

 

[fredg]

I have a report setup that will print activity information for my staff with
totals at the base of their last page. Since some employee's reports may be
1 page others may have 3 to 5 pages. I'd like to number the pages for each
employee. So instead of it showing 'Page 1 of 375' (etc), I need this report
to display 'Page 1 of 2' or 'Page 1 of 5' so that it numbers the pages based
on how many pages that respective employees report is.

How can I do this?

See:
"Printing First and Last Page Numbers for Report Groups "
http://www.mvps.org/access/reports/rpt0013.htm

Things to make sure of:
1) Add a control to the page Footer that computes [Pages]
= [Pages]
You can make this control not visible if you wish.

2) Add an unbound control to the Page Footer.
Name this control "ctlGrpPages"

3) Paste the code into the Page Footer Format event.

4) In the code, change Me!Salesman to
Me![Name of the control used to group by]