Results 1 to 10 of 10

Thread: Page Numbering?

  1. #1
    Join Date
    May 2008
    Posts
    14

    Unanswered: Page Numbering?

    Hi everyone,

    I was wondering if someone might have some suggestions on how to change the page numbering sequence in a report? Since a report can only hold about 3 pages worth of information, I am trying to make several reports that can fit together to make one big report when I print them off. So I will need each report to start at a different page number.

    For example, the first report would be numbered pages 1-3. The second report would be numbered pages 4-6. Etc.

    If anyone has any ideas I would really appreciate it!

    Thank you!!

  2. #2
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Please provide a bit more detail about your report. I assume that the 3 pages refers to design view, but what all are you trying to show (why's it so big).

  3. #3
    Join Date
    May 2008
    Posts
    14
    Thanks for replying!

    The report is just a basic design view report, including text asking and answering questions, and graphs based on queries to show data. It's big because there are many questions the report is trying to cover, and all the text and charts can't fit into one report document. In design view I can only expand the detail length to 22inches at the bottom, which equals out to about 3 pages.

    At the top of the page in design view I have a page header section where I inserted an automatic page numbering box. I am hoping there is some way to change what number it starts at...

    Oh, and is there a way a person can delete their own threads in this forum?

    Thanks a lot!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    there is nothing to stop you putting in your own page numbers in a page footer, and increment the value each time a new page is generated. you could supply the start page number as a parameter to the report opening

    I don't think you will be able to have page xx of yy though
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    No, you can't delete your own threads.

    Too easy really. In your report, where you display the page numbers with an expression such as this:

    ="Page " & [Page] & " of " & [Pages]

    Change it to:

    ="Page " & [Page]+3 & " of " & [Pages]+3

    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Can the questions be put in a table?

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by StarTrekker
    Too easy really. In your report, where you display the page numbers with an expression such as this:

    ="Page " & [Page] & " of " & [Pages]

    Change it to:

    ="Page " & [Page]+3 & " of " & [Pages]+3

    that would work if you know all reports are the same length.
    that would fail if report one bloated (unless you supplied the number of pages in the preceeding report(s))
    it would also fail if there were subsequent reports of variable length / pages

    what I have seen done before (and before the days of ISO14000: lets hug a tree standard & Acrobat) is the master copy of the report is assembled, then muggins hand writes on the bottom of the report page XX: of YY

    another approach is to consolidate all the individual reports as sub reports into one monolithic report package which adds the page xx of yy. its not pretty but it does work. so in this case you'd have master report containing two sub reports (report 1 & report 2)
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I'm with ya there.

    I just offered it since it sounds like the OP is confident it will be 3 pages specifically.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    May 2008
    Posts
    14
    Thanks for the ideas, guys!

    Yes, the questions are in tables- many tables! It's a really (really!) complicated database...

    And each report cannot be more than 3 pages, since I can only expand the design view length of a report document to 22inches which equals out to about 3 pages, but they could be less than three pages if it works out better that way when I fit them all together...

    I will try some of the ideas you guys suggested, but I may have to forego page numbers altogether and just insert physically by hand numbered section pages done up in MSWord into each copy of the final booklet I print off, or something like that... just don't have much time for fiddling around with it- I need to get this booklet finished and I've still got a long way to go without worrying about so many details!



    Thanks again!
    Last edited by Slowlearner; 06-05-08 at 14:55.

  10. #10
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    How many pages is it? You might consider one Main report and several subreports. Without knowing anymore than you have put in this thread I would consider a subreport for each page. Assume that each subreport is physically 9-10 inches in the detail section, add each page to the main report and make them a 1/2 inch tall and allow them to grow using the Can Grow property of the subreport control. That way you can add the page number after each subreport.

Posting Permissions

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