Create a Query

Use the panes in a query tool window to create a query.

To create a query

1. Open a query tool window.

2. To exclude duplicate records from the query results, select Exclude Duplicate Records. For example, if you created a condition for SSN, the system only includes one account with that SSN in the results.

3. To limit the query results to a specific number of records, select Maximum Records and then, in the box, type the maximum number of records to include in the results.

4. If there is a Select Columns pane, do the following as necessary:

• Add one or more columns to the query.

• Delete one or more columns from the query.

• Modify the order of the columns.

• Rename any columns.

5.  In the Conditions pane, do the following as necessary:

• Create one or more conditions for the query.

• Modify one or more conditions.

• Modify the order of the conditions.

• Group conditions for evaluation.

6. In the Order pane, do the steps to Specify the Sort Order for Query Results.

7. To count the number of records that match the selection criteria, in the toolbar, click Count. The results appear in the Query Designer dialog box. Click OK.

8. To run the query, in the toolbar, click Run. The results appear on the Results tab. For more information, see Query Results.

9. To save the query, do the following:

1. In the toolbar, click Save. The Save Query Dialog box appears.

2. In the Query Name box, type a name for the query and then click Save.

Tip: To overwrite an existing query, in the Name column, click the query to overwrite and then click Save.