[MSAccessProfessionals] Combining reports

I have a report due periodically.

In Access it is a combination of 2 reports.

1. r_HealthPremiumCollectionFormAgeBandPost2024
2. r_HealthPlanCobraPremiumSheet

 

The reports are completely different.  The date source is two different queries.  They are also formatted completely different.

Report 1 is a one page bunch of company information such as address, state, number of employees, benefit plan name, etc.

Report 2 is a one page of columns listed by age band.

 

Currently I run each report, convert them into a pdf and then combine the pages in a pdf program, save them and send them off.  It is a slow cumbersome process, especially when I have to do a lot of them.

 

Questions

Is it possible to combine these reports? The first on page 1 and the 2^nd on page 2?

Is it possible to incorporate an automatic export to a pdf?

 

Anything to reduce a few steps.

 

Thanks for your help.

 

Bill

 

Bill Singer

Bill.Singer@at-group.net