Re: [MSAccessProfessionals] Combining reports

Duane,

I Tried this option first and with a bit of formatting it worked. 

 

I was concerned because the reports do not pull information using the same ID number. 

 

But it worked.

 

Thanks,

 

 

 

Bill

 

Bill Singer

Group Benefits Consultant

Phone: 763-754-8898

Fax: 763-754-8496

Toll Free: 877-902-8898

Bill.Singer@at-group.net

 

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Duane Hookom
Sent: Thursday, December 14, 2023 4:22 PM
To: MSAccessProfessionals@groups.io
Subject: Re: [MSAccessProfessionals] Combining reports

 

Hi Bill,

Have you considered placing the one page report into the report footer of the other report?

 

Duane

Sent from my mobile

On Dec 14, 2023, at 10:00 AM, Bill Singer <Bill.Singer@at-group.net> wrote:



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