Examples of expressions for page numbers

Microsoft Office Access 2003

Show All Show All

Examples of expressions for page numbers

The following is a list of examples of page number expressions you can use in form or report Design view and the results that you will see in other views.

  • Expression: =[Page]

    Result: 1, 2, 3

  • Expression: ="Page " & [Page]

    Result: Page 1, Page 2, Page 3

  • Expression: ="Page " & [Page] & " of " & [Pages]

    Result: Page 1 of 3, Page 2 of 3, Page 3 of 3

  • Expression: =[Page] & " of " & [Pages] & " Pages"

    Result: 1 of 3 Pages, 2 of 3 Pages, 3 of 3 Pages

  • Expression: =[Page] & "/"& [Pages] & " Pages"

    Result: 1/3 Pages, 2/3 Pages, 3/3 Pages

  • Expression: =[Country] & " - " & [Page]

    Result: UK - 1, UK - 2, UK - 3

  • Expression: =Format([Page], "000")

    Result: 001, 002, 003