Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006

    Unanswered: Page Numbers Multiple Report

    Hello! I'm hoping you can help me with my problem. I have 3 reports I will be running that are different, but I need continuous page numbers. For example, Report one will have pages 1 through x, report two will have pages x+1 through y, report three will have y+1 through z, etc

    How would I code this?

  2. #2
    Join Date
    Apr 2004
    outside the rim
    Use a couple public variables.

    In report 1, have a function at the end of each page that sets the public variable to the page number: x = [Page], display "Page " & [Page]

    In report 2, have a function that does the same thing, and have it display the sum of the 2: y = [Page], display "Page " & (fnX() + [Page])

    In report 3, do the same thing: z = [Page], display "Page " & (fnX()+fnY()+[Page])

    You will not get the total number of pages until the last page of the third report formats, however, so you won't get "Page X of Y" this way. the only way to get that it to open all 3 reports hidden so you know what x + y +z is (the total number of pages) and then close them and reopen to properly format the page number text box.

    good luck,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts