Group Records for Secure Query
Use the Group Records tab to specify how fields will be grouped
and summarized in your query. Grouped data is data that is divided into
meaningful groups. For example, a group might consist of all those employees
who have the same job title or are in the same department.
- From the Group Records tab, select the fields you want the records grouped by from the drop-down
lists. The values in the drop-down lists depend upon the fields you
have selected from the Select Fields To Use in Query dialog box.
- Select Count
the number of records in the group to add a count of the values
within each group to the query.
- Select Detail
records in the group to display all the data. If you want to display
a summary of the totals for each group, clear the selection. Summary
information is most useful when you do not need detailed information and
you only want to examine totals.
- By default, numeric fields are displayed in the Summarize the records
for this numeric field. From the list of fields, select the one
you want to summarize and click once to highlight it.
- Select the appropriate
radio button or
the type of summary information you want for your query. Secure Query
includes a number of summarizing options:
- None - Displays no summary information.
- Sum the
records in this field - Adds the values within a group, to provide a total.
- Average
the records in this field - Finds the average of all values within a group.
- Find the
smallest value in this field - Finds the minimum value within a group.
- Find the
largest value in this field - Finds the maximum value within a group.