By PDFKits Team — Published July 2, 2026
If you run reports in Microsoft Access, you have probably needed to combine multiple reports into one PDF for sharing or archiving. Access exports each report separately by default, which leaves you juggling several files. The reliable fix is to export each report and then merge the PDFs into one file. This guide shows the manual method, a VBA automation, and the honest trade-offs of each.
| Approach | Best for | Effort | Keeps report order? |
|---|---|---|---|
| Export + merge | One-off report packs | Low | Yes (you choose order) |
| VBA automation | Recurring monthly packs | Setup once | Yes (scripted) |
| Master union report | Reports sharing a layout | Medium | Yes (single report) |
This works in any version of Access:
For recurring tasks, loop through your reports and export each with DoCmd.OutputTo acOutputReport, "ReportName", acFormatPDF, "C:\reports\report.pdf". Once exported, merge them in a single step. Honest limitation: VBA exports the reports but does not merge them, you still need a merge step afterward.
If your reports share a layout, create one report driven by a query that unions the underlying data. A single report exports as one PDF automatically, no merging required. This works best when columns and grouping are consistent across reports.
When merging, confirm the sequence so the combined PDF reads correctly, and check that page sizes match (Letter or A4) so it prints consistently. If the merged file is large, you can compress the PDF before emailing.
Can I combine Access reports into one PDF for free? Yes. Access includes free PDF export, and PDFKits merges the files for free in your browser.
Will merging change my report formatting? No. Merging keeps each report exactly as exported; it only places them into one file.
Is it safe to merge confidential reports online? With PDFKits, files are processed in your browser and never uploaded, so your reports stay on your device.
Combining multiple Access reports into one PDF is simple: export each report, then merge them with PDFKits. For one-off jobs, export and merge manually; for recurring packs, automate the export with VBA and finish with a quick, private merge.