Results 1 to 2 of 2
  1. #1
    Drak is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    22

    Report showing multiple records on one page

    I have a table like so:


    Code:
    [JobID]     [TechID]    [PartsUsed]    [Hours]
    1             2              Part 1             4
    1             2              Part 2             5
    1             2              Part 9             30
    The JobID and TechID are pointed to the primary keys of there respected tables with relationships. I would like to show these 3 fields (all with the same job and employee) on one report. But when I pull up the report with the JobID i want to look at, each field is on it's own page. Is there anyway I can show all this on one page? Should I use VBA, and run the query myself?

    Thanks

  2. #2
    jzwp11 is offline VIP
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2010
    Location
    Dayton, OH
    Posts
    2,901
    It sounds like you have some group levels set up on the report. Each group has some properties that you can adjust. You will want to make sure to keep the whole group together on 1 page.


    In Access 2007/2010, the grouping options are shown along the bottom of the report while in design view. If you do not see them, just click on the Group & Sort icon in the ribbon.

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

Similar Threads

  1. Multiple records on a single page
    By neo651 in forum Forms
    Replies: 1
    Last Post: 06-29-2011, 10:21 PM
  2. Report not showing all records
    By tyguy in forum Reports
    Replies: 6
    Last Post: 05-06-2011, 09:04 AM
  3. Replies: 1
    Last Post: 04-12-2011, 05:19 PM
  4. Replies: 1
    Last Post: 03-19-2010, 05:17 PM
  5. Replies: 7
    Last Post: 12-07-2009, 07:27 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