Re: [MSAccessProfessionals] Combining reports

You should be able to add report 2 as a sub report in report 1.

 

To automate an export VBA code like this should work:

DoCmd.OutputTo acOutputReport, " r_HealthPremiumCollectionFormAgeBandPost2024", "PDFFormat(*.pdf)", "Your path and report name.pdf", False, "", 0

 

 

Doyce Winberry

Manufacturing

Manager Systems

 

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973   M: +1 501-207-2269

 

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Bill Singer
Sent: Thursday, December 14, 2023 10:01 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Combining reports

 

I have a report due periodically. In Access it is a combination of 2 reports. r_HealthPremiumCollectionFormAgeBandPost2024 r_HealthPlanCobraPremiumSheet The reports are completely different.   The date source is two different queries.   They

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

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