[AccessD] Interleaving two reports

Jim Dettman jimdettman at verizon.net
Tue Jan 17 13:25:08 CST 2023


 Why not a main report and a sub-report?  Or two sub reports on a main
report based on the ID with no detail?


-----Original Message-----
From: AccessD On Behalf Of Ryan W
Sent: Tuesday, January 17, 2023 1:37 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: [AccessD] Interleaving two reports

Does anyone have any suggestions on how I can interleave two separate

They both contain data that can be grouped together by an ID, but the
report format is different between them and at the moment my end users are
printing both reports to PDF and then interleaving them in the PDF to
produce the desired report.

My current thought is somehow to use DoCmd.PrintOut and a loop to print an
alternating page range.  I just need to somehow ensure that if the report
per ID is more than one page that gets accounted for as well.
AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list