Appending reports to one file

[rpmrob]

I am generating multiple reports which are being printed as each are generated. Here is a snippet of code to give you some idea:

Dept = "[SendListAllSumQuery]![ContactName]=" & Chr$(34) _
& LabelFlag & Chr$(34)
DoCmd.OpenReport stDocName, acNormal, "", Dept

This code is in a loop which changes "Dept" every pass and hence a different report. The issue I'm having is that I feel the printing would be much faster for all the reports (100's) if the multiple reports were placed in one large file as they are generated, and then print the large file (one print job, as opposed to 100's). Does anyone know how I would place/append the reports to a file ?

Thanks,

Rob

 

[LarryDeLaruelle]

Rob:

Have you considered using the grouping function on department and putting a page break in the department group footer?

This would eliminate the need to use a loop to generate the reports and still provide individual department reports in a single pass.

Larry De Laruelle
ldelaruelle@familychildrenscenter.org