Results 1 to 3 of 3

Report to List Multiple Items

  1. #1
    Join Date
    Aug 2017
    Location
    Batley, United Kingdom
    Posts
    15

    Report to List Multiple Items

    Hello,

    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:	11 
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
    Location
    Kentucky
    Posts
    7,028
    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:
    LINK MASTER FIELD= CN_ID
    LINK CHILD FIELD= CN_ID


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

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    45,528
    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.
    To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

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

Similar Threads

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