Feedback

  • Contents
 

Create an Account Analysis Query

Use the Account Analysis window to query accounts based on specific criteria and analyze the results.

To create an account analysis query

  1. In the Main Menu window, from the Tools menu, click Account Analysis. The Account Analysis window appears.

Account Analysis window

  1. To exclude duplicate records from the query results, select Exclude Duplicate Records.

  2. 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.

  3. In the Select Columns pane, do the following as necessary:

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

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

  2. 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.

  3. To save the query, do the following:

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

Save Query Dialog box

    1. 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.

  1. To run the query, do the steps to Run an Account Analysis Query.

Related Topics

Account Analysis

Queries