totn Access

MS Access 2003: Create a 2 column report

This MSAccess tutorial explains how to create a two column report in Access 2003 (with screenshots and step-by-step instructions).

Question: In Access 2003/XP/2000/97, how can I create a report that shows the report results in 2 columns?

Answer: Let's look at a report to demonstrate.

In our report, we have a ProductName field that we want to display in 2 columns (listed down the page and then across).

Microsoft Access

By default, this report will display the results in a single column down the page, as seen below:

Microsoft Access

To modify this report to display the ProductName values in 2 columns in the Detail section, select Page Setup under the File menu.

Microsoft Access

When the Page Setup window appears, select the Columns tab.

Under "Grid Settings", set the Number of Columns to 2.
Under "Column Size", set the Width to 3".
Under "Column Layout", select the Down, then Across option.

Then click on the OK button.

Microsoft Access

Now when you preview your report, you should see the Product Names listed in 2 columns:

Microsoft Access