Quickie Question re counting pages in a Report

C

c02homer

Access 2003 / XP2

I have a question that I'm sure the solution is simple and I just don't
know how to do it.

I have a report that groups by individuals. Each individual may have
3,4,or 5 pages assigned to them. My problem is that I want the footer
to reflect the number of pages per individual - not the total number of
pages in the entire report. Jones Report - Page 1 of 3 instead of
Jones Report - Page 1 of 150.

Can someone help me with this, please???

Thanks!!
 
F

fredg

Access 2003 / XP2

I have a question that I'm sure the solution is simple and I just don't
know how to do it.

I have a report that groups by individuals. Each individual may have
3,4,or 5 pages assigned to them. My problem is that I want the footer
to reflect the number of pages per individual - not the total number of
pages in the entire report. Jones Report - Page 1 of 3 instead of
Jones Report - Page 1 of 150.

Can someone help me with this, please???

Thanks!!
Click to expand...

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],
i.e. = [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]
 
Top