Resetting Page numbers totals for groups. 1

[Sailalong]

I run reports for clients that must have page numbers in the format “page of pages”. This seems simple enough.

Macro
Page footer Item: [Page]
Expression: 1
Group footer ForceNewPage After Section Starts each group on a new page.

However, using "Page " & [Page] & " of " & [Pages] in the page footer will reset the page for each group but will only give the me total number of pages I am printing. For example, four groups of twenty-five pages will always be 1 of 100 to 25 of 100, never 1 of 25. Is it possible to reset [Pages] to the total number of pages in each group?

Thanks
Sailalong

 

[CosmoKramer]

Check out this thread: thread703-18458

 

[Sailalong]

Thanks!!! After reading the thread I don't feel so dumb. It's nice to know others have problems.