List functions

Most forms provide list functions that allow you to organize data or to summarize data by adding calculations.

List functions

Grouping columns

Use this to group data. Drag the column header you want to group the data on to the grouping box above the column headers. To create a group within the groups, drag another column header to the grouping box.

Click this in a grouped list to collapse the list and hide the details.

Click this in a grouped list to expand the list and show the details.

Use this to add a calculated total to each group in a grouped list.

List totals

Use this to add a calculated total to a list.