Group and sort data

Grouping and sorting data in a report

One of the more powerful things you can do in a report is group and sort your data. For example, if you want to know which supplier provided a given set of computers, then grouping your assets by supplier can give you that information quickly and easily.

You can group tabular or stacked reports.

Open your report in Layout view, and on the Design tab, in the Grouping & Totals group, click Group & Sort. The Group, Sort, and Total pane appears below your report.

In the pane, click Add a group, and then select the field by which you want to group your data. Access groups your data to reflect your choice.

If you want to sort your data, click Add a sort, select a field, and again Layout view shows you your changes.

You can add 10 grouping levels to a report, and you can sort each level, if you need to.

Topic 4 of 10

Previous | Next

(Back to Start)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!