Set Custom Filter Criteria

Use the Enter Filter Criteria for... dialog box to customize selection criteria for any column in the query results. You can combine selection criteria (or conditions) to create more complex filters.

To set custom filter criteria

1. Create a Query or Open an Existing Query.

2. In the toolbar, click Run. The results appear on the Results tab. The following example shows the Results tab in the Account Analysis window.

3. In the column heading of the column to filter, click the Funnel icon . A list of options for the specified column appears.

4. Click (Custom). The Enter Filter Criteria for... dialog box appears. The following example shows the dialog box for the Customer column.

5. In the Operand list box, click an operator. For more information, see Custom Filter Operators.

6. In the Operand list box, click or type an operand. In the previous example, the operator is "= Equals" and the operand is "0000001 - CUSTOMER ONE." The condition appears in the lower portion of the dialog box.

7. To add conditions, click Add a condition. The system adds a blank row.

8. To delete a condition, click the condition and then click Delete Condition.

9. If you set multiple conditions, do one of the following:

• To set the filter so that all the conditions have to be true for an account to appear in the query results, click And conditions. For example, customer doesn't equal "0000001 - CUSTOMER ONE" and customer does not equal "0000002 - CUSTOMER TWO" means to select accounts for all customers except Customer One and Customer Two.  

• To set the filter so that only one condition has to be true for an account to appear in the query results, click Or conditions. For example, customer equals "0000001 - CUSTOMER ONE" or customer equals "0000002 - CUSTOMER TWO" means to select accounts for Customer One or Customer Two.

10. When finished creating the custom filter, click OK.

Related Topics

Query Results