Page numbers in Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with about 75 pages and 25 different groups. How can I get
the page number to count pages in each group instead of for the entire
report?

Thanks
 
I have a report with about 75 pages and 25 different groups. How can I get
the page number to count pages in each group instead of for the entire
report?

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]
= [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]
 
Lisa said:
I have a report with about 75 pages and 25 different groups. How can I get
the page number to count pages in each group instead of for the entire
report?
Click to expand...


Assuming you are grouping on each of your "group"
identifiers abd that the group header section's ForceNewPage
property is set to Before Section.

You can easily use the group header section's Format event
to set the Page property to 1.

To display/use the Pages for each group, look at
http://support.microsoft.com/kb/841779/en-us
 
Back
Top