Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Page numbers - resetting totals for each group

Status
Not open for further replies.

Guy999

Programmer
Apr 1, 2002
27
GB
Hi,
I have a report that generates separate invoices for all the companies in a table in one go. I have made a small macro that resets the page number to 1 (when company id changes) so that for each company report page number starts with 1, but I was wondering if it's also possible to show the total pages for each company too.

eg
First company - Page 1 of 4, Page 2 of 4 etc
Second company - Page 1 of 2 etc

I've only managed to show the total number of pages for the whole report, not by company.

Thanks,
Guy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top