Merge reports into one report in Access

[Tim]

Hi folks,

I have 5 reports in my database. I want to merge them
into one report in Access97. Does anyone know the way to
do it?

The following is my example:

Rpt1
Rpt2
Rpt3
Rpt4
Rpt5

Merge to RptM and run the following code.

Public Sub test()
DoCmd.OutputTo acOutputReport, "RptM",
acFormatRTF, "c:\temp\RptM.rtf"
End Sub

Thanks in advance.

Tim.

 

[Larry Linson]

You can embed each of the five reports into a Subreport Control in a new
main report. You'll need to tweak the Report Headers, etc., if there's
important information there.

Larry Linson
Microsoft Access MVP