Results 1 to 3 of 3

Thread: Brain Lapse...

  1. #1
    Join Date
    May 2008
    Raleigh, NC

    Unanswered: Brain Lapse...

    Hi Everyone,

    I'm having a serious brain lapse here. I have a report that is many, many pages long. It creates a page break after each investigator so a seperate 'report' may be mailed to each individual. The default page count in the report footer is ="Page " & [Page] & " of " & [Pages]. What I want to do is reset the [Page] and [Pages] to reflect what is accurate for that investigator, such as Page 1 of 2 and not Page 33 of 1,854.

    Make sense? Thanks all!
    --If its free, take it for what its worth!

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you may have to do your own page numbers, set them to 1 on change of investigator header, and add one each time you start a new page, or finish the old page

    you will loose the page n of n, but I've always thought that as mebbe a bit to anal.... just because we can print it we print it
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2007
    Adelaide, South Australia
    Either that or loop through each investigator and print a report for each.
    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

Posting Permissions

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