[Page] Of [Pages] problem in a Report

[gregghoush]

I am using access's built in report designer. And i am printing a report that will print every cusotmers record. each customers # of pages might vary, one might have 3, one might have 2, the Pages object would have the TOTAL pages, like 80. I need eac hcustoemrs pages to say "Page 1 of 4" if that customers pages is only 4. I can get he [Page] object/property to reset to 1, using a macro. I cant however get the total count of pages for that customerID, any idea's?

[bashfirst]

You may have a difficult time with this... the Pages property knows the total pages in the report... and on any given page you know what page you are up to... but I don't think there is a way to know how many pages are in a section.

One way to make it work would be to call the report repeatedly using a list of customers in the filter of the OpenReport call. That way each Customer would be one complete report and would have the appropriate number of Pages listed.

Hope this helps.
Bash