How can I Print multiple Reports all Linked to a field?

[Gary]

I am using Access 2000-2003.

I have 8 reports that are are printed separately. Now I have a requirement
to print all 8 reports together, but frequency sort by a linked field which
is common to all of the 8 individual reports.

For example, the linked field has the sequence {x, y, z}. I was thinking on
using the DoCmd.OpenReport ("Report Name", acViewNormal).

I originally tried putting 8 of these on a report with the linked field to
all eight. I had to put a page break between each of the e reports. I
didn't need the OpenReport here.

This works, but if the report doesn't have any record in the link field, a
blank page appears.

My question, what is the best way for me to do this without generating those
blank pages. But I do want the new report to start on a new page.

Can someone please help.

Thanks,

G