Avatar of Delano29
Delano29Flag for United States of America asked on

MS Access Separated two Report Details for a Main and Subreport

Hi – I am using MS Access 2013.  I have created two reports based on two separate queries.  The tables that the queries are based on are linked by the field RecordID.  I am using ‘Report1’ as the main report and ‘Report2’ as the subreport.  I have created a third report ‘Report3’ that combines both report1 and report 2.  My problem is when I run report3 the details from Report1 and Report2 are mixed together.  I would get a record from Report1 and then I would get record from Report2 in no particular order.

I would like to keep the detail information separated.  I would like it to print all the details from ‘Report1’ (main report) first then display all the details from ‘Report2’ (subreport).  Is there a way to insert another Detail Section (two sections in total).  Is this possible? or could someone suggest a better option?

This is format that I would like the report to look like:

ATTORNEY: info) placed in Report Header)

ASSOCIATE1: info (placed in Detail Section)
ASSOCIATE2  
ASSOCIATE3

Case1 info (placed in Detail Section)
  Witness1 info
  Witness2 info

CASE2: info (placed in Detail Section)
 Witness1 info
 Witness2 info
 Witness3 info
 Witness4 info

CASE2: info
  Witness1 info
  Witness2 info

CASE3: info
  Witness1 info
  Witness2 info

The bottomline is there anyway to force it to print all the details from the first report first before it starts printing the details from the second or subreport?

I have attached an example database with the reports.
lawoffice.accdb
Microsoft Access

Avatar of undefined
Last Comment
Delano29

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Delano29

Thanks.  That worked great. You saved me from a lot of frustration.  Now I just have to figure out how to stop blank records or fields from printing.
SOLUTION
Jim Dettman (EE MVE)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Delano29

Thanks again.  I will try these.  If I am still having trouble I will open another question.
Your help has saved me hundreds of hours of internet surfing.
fblack61