Delano29
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again. I will try these. If I am still having trouble I will open another question.
ASKER