How to print a report footer “page X of Y”, where X is the current and Y is the total.
Q: Don Fox wants to know how to print a report footer “Page x of y”, where x is the current page and y is the total number of pages.
A: Use the following expression as the control source of a textbox in the page footer of the report:
=”Page ” & [Page] & ” of ” & [Pages]
(note that the syntax given in the Common Expressions section of the Expression Builder is incorrect).