How To Group A Report By Multiple Fields In Access

Group report is a report where one or more fields are used to group the other fields. Access has such useful feature that helps you to create reports that are grouped on more than one field. So, now you can group a report on multiple fields quite easily using the Report Wizard in Access 2016.

Below here is the complete step to create a report that is grouped on two fields.

Steps To Group A Report By Multiple Fields In Access 2016


From the Create tab, click Report Wizard on the Ribbon.


Make selection for the fields that you like to appear on the report. You can select fields from more than one table or query.

Select a table or query using drop-down list. After then make double click a field from the left pane to move it across to the right pane. Repeat this for each field which you want to display in the report. Fields present in the right pane will appear in the report.

Repeat this for relevant query/table. After completing all this, click next.


In the left pane, make selection for the table or query that contains the field that the report needs to be grouped by. This is the first level grouping in which others fields are grouped.

In the right pane you can see the preview based on your selection and click to the Next option.


Now, you need to select the second field to be grouped on. This field, if selected is inserted between the first level grouping and the other fields. Click Next.


You can specify fields to sort the report details by. This sorts the fields within each group (not the grouped fields). Once done, click Next.


Make selection for the preset layouts for the report.

The preview gets updated automatically when you select an item. So, check each of them one by one to see its affects on the layout.

You can make changes in the orientation to Landscape if needed. Once it gets over, click to the next option.


Assign name to your report. Well you have the option of either previewing the report or modifying its design once the wizard has finished creating it.

Tap to the Finish option, as this will start generating the report.


Your report is now ready. It has two levels of grouping, as you have specified.