Results 1 to 6 of 6
  1. #1
    KenSmellsGood is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    2

    Additional Pages mimicking a report


    I currently working on a report as part of my internship and have run into some issues. I attached a screen shot of the report.

    Is there a way to set this report up so that each record from the query that it's built on is displayed like this on additional pages? I had to create the report from scratch because the wizard couldn't handle the number of fields that I needed to include.
    Attached Thumbnails Attached Thumbnails image.png  

  2. #2
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    I guess I don't understand your question.
    Will your report be more than 1 page?

    Dale

  3. #3
    KenSmellsGood is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    2
    Yes. Right now it is one page and I'd like each of the following pages to contain another record. So the next page would consist of the next record, page 3 would consist of the next record, and so on.

    The main problem is that it's only showing the first record even though I removed the parameter from the query.

  4. #4
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Just a guess (still on my first coffee) that is all that is in the query.
    If you put all the data in the underlying query that you want to show on the report, the report will keep going until all the data has been shown.

    I simple terms, you only have enough data for one recordset in the query. Check your query.

    Dale

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    As rzw0wr says, make sure the RecordSource is not filtered to retrieve only the one inspection.

    If you want to provide db for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    rzw0wr is offline I will always be a newbie
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2013
    Location
    Indiana
    Posts
    479
    Are you trying to print a report about more than 1 subject?
    Example more than 1 person, place or thing.

    Dale

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Why would my reports print additional repeated pages?
    By ShovelingFishHeads in forum Reports
    Replies: 1
    Last Post: 10-13-2012, 12:20 PM
  2. additional pages
    By snoopy in forum Reports
    Replies: 3
    Last Post: 06-15-2012, 02:06 AM
  3. Replies: 9
    Last Post: 01-27-2012, 12:52 AM
  4. Report pages
    By combine21 in forum Reports
    Replies: 1
    Last Post: 03-05-2011, 04:39 PM
  5. Blank pages between report pages
    By jonsuns7 in forum Reports
    Replies: 2
    Last Post: 10-01-2009, 05:06 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums