Page X of Y - resetting Y

[Guest]

I have a report where I'm interested in printing "page X of Y" at the bottom
of each page. I am intending to print 150 different reports (based on
printing a separate report for each employee) in one report run/print and
want the page number representation to be accurate for that employee's
section only.

For example, the entire report for all 150 employees is 2,000 pages.
Employee 75's report in the middle of the run is 8 pages. So I want those 8
pages to print page 1 of 8, page 2 of 8, etc.

I've done this years ago, but I don't use reports often enough to remember
how I set this up. The control source for the page numbering is '="Page " &
[Page] & " of " & [Pages]'. I used the Help function for resetting the
[Page] element to 1 on each new employee section. But I can't get the
[Pages] element to reset to the count for that employee's total page count.

Any help will be appreciated.

Thanks

 

[Marshall Barton]

I have a report where I'm interested in printing "page X of Y" at the bottom
of each page. I am intending to print 150 different reports (based on
printing a separate report for each employee) in one report run/print and
want the page number representation to be accurate for that employee's
section only.

For example, the entire report for all 150 employees is 2,000 pages.
Employee 75's report in the middle of the run is 8 pages. So I want those 8
pages to print page 1 of 8, page 2 of 8, etc.

I've done this years ago, but I don't use reports often enough to remember
how I set this up. The control source for the page numbering is '="Page " &
[Page] & " of " & [Pages]'. I used the Help function for resetting the
[Page] element to 1 on each new employee section. But I can't get the
[Pages] element to reset to the count for that employee's total page count.

Here's A KB article that describes how that can be done:

http://support.microsoft.com/default.aspx?scid=kb;en-us;841779