In my Access Report I reset the group page numbers as described by Microsoft.
Group Header, Force New Page - Before Section
Group Footer, On Format - PageResetHeader
PageResetHeader macro, SetValue Item [Page] Expression 0
The page numbers for each group are correct except in the instances where the group footer winds up on a page without any detail records. On a group where the detail records show on the first 2 pages, but the footer goes to the 3rd, I get Page 1, Page 2, Page 1. (The only thing on the last page of the group is the header and the footer.)
How do I fix this?