Show All

Create a multiple-column report

1. Create a report and open it in Design view.
2. On the File menu, click Page Setup.
3. In the Page Setup dialog box, click the Columns tab.
4. Under Grid Settings, in the Number Of Columns box, type the number of columns you want on each page.
5. In the Row Spacing box, type the amount of vertical space you want between each record in the detail section.

   Note  If you left space between the last control in the detail section and the bottom edge of the detail section, you can leave Row Spacing set to 0.

6. In the Column Spacing box, type the amount of space you want between the columns.
7. Under Column Size, type the width you want for a column in the Width box. You can set the height of the detail section by typing a number in the Height box or by adjusting the height of the section in Design view.
8. Under Column Layout, click Down, Then Across or Across, Then Down.
9. Click the Page tab.
10. Under Orientation, click Portrait or Landscape.

Notes

• When a multiple-column report is printed, the report header and footer and page header and footer span the full width of the report, but the group header and footer and detail section of a multiple-column report span the width of one column.

• The Products by Category report in the Northwind sample database displays data in multiple columns. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Products by Category report in Design view.