Set the sort and group options

1. To specify a sort order for the query results or filter on aggregate values, select the Set sort and group options tab.

2. Under Select results fields for sorting or group filters, the output fields selected on the Select filter and output fields tab appear. Select the fields to sort by and drag them under Sort records by.

3. Under Sort records by, include the fields to sort by and select whether to sort in ascending or descending order. Sort fields are optional. For example, to create a query to list the name and home telephone number of individuals, you can select an ascending sorting order by last name of the individual.

4. Under Include records where, filter on aggregate values of filter fields. For example, to return the names and date added information for all system administrators added to the system as of a specific date:

   1. On the Select filter and output fields tab, select the Date added field and select MIN from the Summarize option.

   2. On the Set sort and group options tab, drag MIN (Date added) under Include records where and enter the date to use as criteria.

5. To browse the query results, select the Preview results tab. For information about the items on this tab, refer to Preview the results.

   Otherwise, select the Set save options tab and specify the properties of the query. For information about the items on this tab, refer to Set query properties.