Filter Query Results

Use the Results tab in the Select Accounts window to filter query results.

To filter query results

With the Select Accounts window open, in the toolbar, click Run. The results appear on the Results tab.

Select Accounts window - Results tab

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

Results tab - filter

(All): If selected, the system didn't filter the results.

(Custom): If selected, allows you to set custom filtering conditions.

(Blanks): If selected, the system limits the results to accounts with a blank or null value in the specified column.

(NonBlanks): If selected, the system limits the results to accounts that don't have a blank or null value in the specified column.

Click any value other than (Custom). The list closes and the query results only include the records that match the specified filter.
To set custom filter criteria, do the steps to Set Custom Filter Criteria.