two reports in one

R

Richard

Hi

Am I able to print two reports in a report. As in Page one, query 1; page 2
query 2.

Now I am opening two reports as Page 1 and Page 2.

Many thanks in advance
RIchard
 
J

Jeff Boyce

Richard

Create Report1 based on Query1. Create Report2 based on Query2. Create
Report3 based on nothing.

Open Report3 in design view, add Report1 and Report2 as sub-reports.

If you want a page break between them, add that control on the Report3
definition.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
R

Richard

Hi Jeff

Many thanks for the tip

Richard

Jeff Boyce said:
Richard

Create Report1 based on Query1. Create Report2 based on Query2. Create
Report3 based on nothing.

Open Report3 in design view, add Report1 and Report2 as sub-reports.

If you want a page break between them, add that control on the Report3
definition.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top