Combining 2 reports into one, alternating

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
 
L

Larry Linson

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
 
Top