Summarize results

The summarize function enables you to generate a summary table according to fields you select, and then display records matching the summary filter.

Procedure

  1. Click the Summarize/Group button ( Summarize/Group icon ). The Summary dialog is displayed.
  2. Select one or more fields to group by. Use Ctrl-click to add a field to the list of selected fields.
  3. Click the Summarize button. A table appears, listing the number of rows that have the same values for each combination of the selected fields.
  4. 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.