Collating reports

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

I have two different reports that are generated from the same table. They are
sorted by customer, generally one page per customer. I would like to be able
to print the reports collated together, as follows:

Report 1, Customer 1
Report 2, Customer 1
Report 1, Customer 2
Report 2, Customer 2, etc.

Is there a way to accomplish this in Access 2007?
 
Place report 2 in report 1 as a subreport.

In report 1, create a group footer based on the CustomerID.
Add report 2 there as a subreport.

Make sure the LinkMasterFields/LinkChildFields properties are set to
CustomerID, so the subreport only shows the records for the matching
customer in the main report.
 
Back
Top