I have a report that generates purchase orders. The reports are grouped by company name, so it generates a new purchase order number for each company name. I have a textbox that issues a page number in the company header section with this control source; ="Page " & [Page] & " of " & [Pages].
My problem is that the page numbers are continuous, even though my purchase orders are seperated by groups based on company name. Is there a way that page numbers can start from page 1 within each group?
for example;
Comany A may have pages 1 through 3
While company B may have pages 1 & 2
and company C may only have page 1
thanks any input is greatly appreciated,
Steve