Create a Query Condition

Use the Conditions pane on the Account Analysis page to specify the criteria for which data to include in the query results.

To create a query condition

1. Ensure that a query is open on the Account Analysis page.

2. In the Data Selection tree, expand nodes to locate the data item to include as a condition.

3. Drag and drop the data item into the Conditions pane or right-click the data item and select Add to Conditions from the list.

The following example shows the criteria for the Account Open? condition.

4. Specify the criteria, and then click OK.

5. Continue adding conditions as necessary.

6. To apply the And operator, do the following:

1. After adding the required conditions to the Conditions pane, click And.

2. In the toolbar, click Count. The results appear in the Query Designer dialog box. Click OK.

7. To apply the OR operator, do the following:

1. After adding the required conditions to the Conditions pane, click Or.

2. In the toolbar, click Count. The results appear in the Query Designer dialog box. Click OK.

Related Topics

Query Conditions

Create an Account Analysis Query

Modify an Account Analysis Query

Account Analysis