How to Create Multi Column Reports MS Access

Quick summary

Creating multi-column reports in Microsoft Access lets you display data in a structured, side-by-side layout for more readable printouts. Use Page Setup and the Columns settings in Design View to configure column count, width, and layout in just a few steps.

Steps

1. Open the report in Design View.
2. Click Add Existing Fields to add fields to the report.
3. Open Page Setup and click on it.
4. Go to the Page Layout group on the ribbon and select Columns.
5. Set the Number of Columns to the desired number.
6. Adjust the Column Width and Row Spacing as needed.
7. Select a Column Layout.
8. Click OK to apply and proceed.