Page numbering

  • Thread starter Thread starter William Taylor
  • Start date Start date
W

William Taylor

I 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.
 
I 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.
Click to expand...

See the report section at:
http://www.mvps.org/access

Make sure you include a control on the report that computes [Pages].
 
Back
Top