I've got a report I'm working on with a Textbox in the footer containing the following:
"="Page " & [Page] & " of " & [Pages]"
When I get to the print preview of the report when there are 3 pages, they all say there are only 2 pages. Meaning page 1 says, "Page 1 of 2"; page 2 says, "Page 2 of 2"; and page 3 says, "Page 3 of 2".
The number of pages in the report can change depending on the subject of the report. This problem does not occur if there are only 1 or 2 pages in the report.
Any ideas what could be causing this discrepancy?
Thanks