Results 1 to 3 of 3
  1. #1
    Pawtang's Avatar
    Pawtang is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    91

    Reporting/Subreporting: Multiple records, each with multiple related records

    I return to you, Access Forums, in my time of need, because I have come far in my quest to improve our data handling, and have come upon a new frontier.

    I am trying to generate a report that, for 5 chosen records, shows each of the related records and record data on the page. Each primary record should have its own page. Currently I have related master-child on RMA_nb, and the result is that I am shown a header with one RMA_nb, and then a detail section displaying one related record per RMA_nb. If I failed to explain this clearly, please ask any necessary questions and I will answer. These visuals may help:

    All data table relationships:
    Click image for larger version. 

Name:	1.png 
Views:	16 
Size:	50.9 KB 
ID:	46107

    RMA_nb primary query:
    Click image for larger version. 

Name:	qryRMAsToClose.PNG 
Views:	16 
Size:	22.6 KB 
ID:	46108



    Subreport query:
    Click image for larger version. 

Name:	qryRMAsToCloseSub.PNG 
Views:	17 
Size:	26.2 KB 
ID:	46109

    Report design:
    Click image for larger version. 

Name:	Report.PNG 
Views:	16 
Size:	28.3 KB 
ID:	46106

    Report result:
    Click image for larger version. 

Name:	report_result.PNG 
Views:	16 
Size:	32.3 KB 
ID:	46110

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Not entirely clear to me.

    Primary record is a customer?

    Could try setting ForceNewPage property on the main report Detail section.

    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.

  3. #3
    Pawtang's Avatar
    Pawtang is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Mar 2021
    Posts
    91
    Long story short, I was having problems because I was trying to group things within a subreport, which I think may be possible but is a lot more complicated. I ended up just building a report based on two joined queries and was able to group much more effectively that way.

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

Similar Threads

  1. Get multiple rows from related records
    By Gina Maylone in forum Access
    Replies: 7
    Last Post: 01-21-2019, 08:13 AM
  2. Combining Multiple Related Records Into One Field
    By Hendro623 in forum Programming
    Replies: 4
    Last Post: 12-21-2016, 01:43 PM
  3. Replies: 6
    Last Post: 02-21-2014, 04:58 PM
  4. Replies: 2
    Last Post: 01-12-2014, 04:47 AM
  5. Replies: 9
    Last Post: 01-26-2013, 11:06 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
  •  
Other Forums: Microsoft Office Forums