Combining 2 reports into one, alternating

  • Thread starter Thread starter -Michelle-
  • Start date Start date
M

-Michelle-

Hi

Using A2002

I have 2 separate reports which need to remain separate because they need to
be printed separately under different circumstances, but in one circumstance
I need to combine them.

I will clarify further: I will need to print this combined report, for all
records, doublesided, with 'Report1' on side 1 of the paper and 'Report 2'
on side 2 for each record. (This is not a matter of running Report 1 to for
all records, followed by Report 2).

Has anyone got any suggestions on the best way to go about this?

TIA
Michelle
 
Interspersing records from two reports isn't the way Access reporting works,
as I'm sure you know.

I understand from what you've said that there are corresponding records in
Report 1 and Report 2, and you want each page to have the record from Report
1 printed on the front and the record with the same ID from Report 2 on the
back.

One workaround that occurs to me is to "drive" your report with a query that
just returns the unique ID you are using to match records, from the same
RecordSource as Report 1. Set the Force New Page Property for each Record.
Create a Subreport Control for each Report1 and Report2. Between those
subreports from the Toolbox, Insert Page Break. Set your printer to manually
or automatically print double-sided.

Larry Linson
Microsoft Access MVP
 
Back
Top