Page numbers in Report

[Lisa]

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

 

[fredg]

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

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]

 

[Marshall Barton]

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?

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