Multiple Reports Outputing to one file

[bwalk037]

Hello all,

I have two reports I have made in Access. Is there a way to create an Access report that allows one report to flow right into the other report? Or have Access export both reports to the same file in Word? That way if I was to print out the report in Word it would just be one document and I could just flip through the one document and have both reports.


Thank you.

 

[clinthicum]

I'm also anxious to learn how to do this as well. I have an executive report that is compiled of 20 different pages (call them sub-reports?). I would like to use Access to generate each of the 20 pages (currently seperate reports in Access, due to varying layout and content on each page) for each of my projects...and print all 20 pages/reports at once. What I don't have time to do, is pull up each report for each project and hit File-Print or File-SaveAs 20x times.

I'm a fan of PDF995 and Adobe Acrobat. It would be great if I could just run a macro or something to crank out the 20 pages for a particular project and then combine or compile those 20 pages into one PDF document that is 20 pages long, etc.

 

[BamaColtsFan]

Ok, so I'm wondering of anyone ever found the answer to this one? I have the same problem!

 

[vbaInet]

Ok, so I'm wondering of anyone ever found the answer to this one? I have the same problem!

Which one are you referring to?