Results 1 to 3 of 3

Report to List Multiple Items

  1. #1
    Join Date
    Aug 2017
    Batley, United Kingdom

    Report to List Multiple Items


    Hopefully I can explain this correctly....

    I am trying to create a report from a Query based on two tables.

    Table 1, being the main table called tbl Change Notes
    Table 2, being the secondary table called tbl Change Details

    Change Notes table captures information for a particular change that is being requested with the following details being captured:

    • CN_ID
    • CN_No
    • DateOriginated
    • DocumentAffected
    • IssueNo
    • RequestedBy
    • ChangeReason
    • AuthorisedBy
    • AuthorisedDate
    • ImplementationDate
    • IssuedBy
    • Comment
    • Authorised

    Change Note Details is a table that captures a list of items that have been changed within the Change Note table.

    These are the fields:

    • ChangeID
    • CN_ID
    • Details of Change
    • ChangeType

    What I want to do, but can't get to work:

    I would like to create a report that is one record per page. I want the report to display all the details from the Change Notes table and then have a section where it lists the Change Note Details (this can be multiple items).

    I have managed to create a report and it is almost how I want it, but I cannot figure out how to get the report to list the multiple items? It only seems to list on item?

    Does that make sense?

    Here is an example of the report with the fields inserted and highlighting the area where I am struggling:

    Click image for larger version. 

Name:	example.jpg 
Views:	12 
Size:	94.3 KB 
ID:	35780

    Any help or advice would be greatly appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    the report will be bound to Table1,
    in the detail area, you put a subreport box,
    this will have the table/query for Table2

    set the subrpt properties:

    The REASON FOR CHANGE boxes ,(and all data under it ) go under the SubRpt box.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    The Great Land
    A subreport might not be required if report Sorting & Grouping is used in design. Set a GROUPING on Table1 CN_ID and put Table1 fields in group header and footer. Put Table2 fields in Details section. Set report to force new page after Group footer. Downside is will likely get a blank page at end.
    How to attach file: To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 7
    Last Post: 06-20-2013, 12:09 PM
  2. Replies: 3
    Last Post: 10-23-2012, 03:32 PM
  3. Select multiple items from list box
    By sharmaprashant22 in forum Queries
    Replies: 2
    Last Post: 05-05-2011, 12:18 PM
  4. Replies: 5
    Last Post: 04-04-2011, 09:57 AM
  5. Replies: 1
    Last Post: 11-11-2006, 08:23 PM

Tags for this Thread

Posting Permissions

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