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)
Case1 info (placed in Detail Section)
CASE2: info (placed in Detail Section)
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?
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.