Collating reports

[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?

 

[Allen Browne]

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.