Page numbers

[William Taylor]

create reports that often are grouped by location, etc. I want to put page
numbers and total pages per group. Access default is to number the entire
report. What I need is when it breaks on my group to start at 1 and tally
the page total for that group if it is possible.
Example to clarify:
I have a report that is creating inventory transfers to multiple locations
from the main warehouse. currently the report page number and total are
based on the entire report for all locations. So when I send that transfer
report to each location they see page 1 of 24, page 2 of 24, etc. the second
location see's 4 of 24, 5 of 24, etc.
What I want is for each grouping to number as such: page 1 of 3 for the
first location, and start over when it breaks across that group.

 

[Cheryl Fischer]

There is a technique described at:

http://www.mvps.org/access/reports/rpt0013.htm

that will do that for you. Make sure you include a control on the report
that computes [Pages].

hth,