Re: [MSAccessProfessionals] Combining reports

as suggested, create a new report and put (drag) the two separate reports as sub-report.

if each separate reports are but 1 page long, you can separate them on each by adding a Page Break Control

between them on the new report.

On Fri, Dec 15, 2023 at 12: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

 

 

 

--

Arnelito G. Puzon

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116497) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_