I have a report that has the total number of pages displayed in the footer. (The typical ="Page " & [Page] & " of " & [Pages].) When the report is previewed or printed, the total number of pages is less than the actual total. So it will show up as Page 198 of 199, Page 199 of 199, Page 200 of 199, Page 201 of 199, etc. So the page number is correct, but not the total.

Any thoughts?

(using Access 2002)