Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Location
    California
    Posts
    11

    Unanswered: Report has multiple duplicate pages...

    Hello to all,

    I have created a report based on a query. The query has multiple fields that contain either yes or no as the values. On my report, I have created multiple unbound fields that calculate the number of Yes values and No values for each field in the query.

    I have placed all the labels and unbound fields in the detail section of the report. When I run the report, everything is displayed perfectly with the correct totals.

    My problem is... that the labels and lines in the detail section repeats itself on 3 pages. I believe the margins are set properly being that it visually looks good for each page. I just don't want the duplicate pages....

    Thank you in advance for any help you can give me!!!!!!

    SgtDep

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    What's the code of your query, what's the code you use to perform calculations on your report etc... Without proper information it's hard to answer.

    Have a nice day!

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The query returns 3 records, so the detail section is repeated 3 times?

    That's my first guess!
    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
  •