Start each group in a report in a new row or column

1. Create a multiple-column report that has at least one group level.

   For information on creating a multiple-column report, click . For information on creating group levels, click .

2. In report Design view, click Page Setup on the File menu.
   
   
3. Click the Columns tab. Under Grid Settings, make sure Number of Columns is set to a value greater than 1.
   
   
4. Under Column Layout, do one of the following:
   • To start each group in a new column, click the Down, Then Across option.
     
     
   • To start each group in a new row, click the Across, Then Down option.
5. Click OK.
   
   
6. Double-click the section selector for the group header or footer to display its property sheet.
   
   
7. Set the NewRowOrCol property to one of the following settings.

   Setting	Description
   None	(Default) The row or column breaks are determined by the setting in the Page Setup dialog box and by the available space on the page.
   Before Section	Microsoft Access starts printing the current section (the section for which you're setting the property, such as the group header) in a new row or column. It starts printing the next section, for example, the detail section, in the same row or column.
   After Section	Microsoft Access starts printing the current section, such as the group header, in the current row or column. It starts printing the next section, such as a detail section, in the next row or column.
   Before & After	Microsoft Access starts printing the current section, such as the group header, in a new row or column. It starts printing the next section, such as the detail section, in the next row or column.

Notes  

• To see an example of a report that starts each group in a new column and an example that starts each group in a new row, click .
  
  
• The Products by Category report in the Northwind sample database starts each group in a new column. 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. For information on opening Northwind, click .