The summarize function enables you to generate a summary
table according to fields you select, and then display records matching
the summary filter.
Procedure
- Click the Summarize/Group button
(
). The Summary dialog
is displayed.
- Select one or more fields to group by. Use Ctrl-click
to add a field to the list of selected fields.
- Click the Summarize button. A table appears, listing the number of rows that have the same
values for each combination of the selected fields.
- To focus on the rows belonging to a particular grouping,
select a row from the table of summary groups and click Apply. The table view is refreshed to display only the rows belonging
to the selected summary group.
What to do next
To restore the full list, click
Clear Grouping.
To close the
Summary dialog,
click
Close.