Renumbering pages on an Access 2002 report

I have an Access 2002 report that generally runs around 40 to 50 pages.  Within those pages there is a high level grouping.  I have a user that would like to collate and staple these reports, however, their printer doesn't seem to handle it properly becuase the report page numbers run from 1 of 50 to 50 of 50.  I would like to know if there is a way in code to restart the numbering of the pages for each group so instead of it running 1 to 50, it runs 1 to 10 five times for example.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
see if the codes from this link helps
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

and just to make sure the bases are covered:

How to reset the page number and the total page count for each group in a Microsoft Access report

  In case you want to do "Page X of Y" for each group where Y is the number of pages per group.

Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Jeffrey CoachmanMIS LiasonCommented:

What I have also done in the past is to loop the groups and simply print each group as a separate report.

So if each group is an employee, I would loop the employees table and filter the report for each.
Something like this in a recordset
    DoCmd.OpenReport "ReportName", , , "EmpID=" & rst!EmpID, acHidden

In my case, the advantage was that:
1. The report did not need to be modified in any way
2. each "Report" had the same Report Header and footer.
3. The printer could be set up to staple each "Print Job", so each group was stapled automatically.

A final note to what Jim posted...
I actually did a custom numbering scheme like:
Group1, Page 1 of 5 pages
Group1, Page 2 of 5 pages
Group2, Page 1 of 5 pages
Group2, Page 2 of 5 pages
Group2, Page 3 of 5 pages

I'll try to dig it up if it helps


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
If the printer has the ability to staple groups then JeffCoachman suggestion is the way to go. I have had good luck doing that with sever different printers.  The key is that each group is sent as a separated print job. This is done by send each group as a separate report. If they are separate report then page number can be handle with the standard page numbering.
SpaceCoastLifeAuthor Commented:
Because of the need to collate and staple they have to be sent as separate jobs.  Thanks much for the help!
Jeffrey CoachmanMIS LiasonCommented:

This is a pleasant surprise because my post was just a shot in the dark because you mentioned "collation"

The other links the other Experts posted are also great resources.

The other reason I posted this was because of what I encountered a while ago.

While spending quite some time coding that crazy page numbering scheme:
    Page 1 of 2 for Group 1, out of 3 groups and 14 total Report pages
    Page 2 of 2 for Group 1, out of 3 groups and 14 total Report pages

...The client asked if it might be faster to just print each group individually.
This way no custom coding or report modifications would be needed.
(Yes, I still had to create a query of only customers with orders, and loop it, ...but this was all on the calling form)

As always, the benefit of questions like this is to explore all the options.
I have no issue with you deciding to split the points...


It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.