Skip to content

Printing Page X of Y in a Report Footer

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).

About this author