While in a window
that lists a group of records, click on the Filter
button in the toolbar in the top right corner of the window.
The Filter window opens.
The list includes all columns that are available to be displayed in
the source window, even if they aren't all currently displayed.
All columns used as pinned filters are at the top of the list, followed
by displayed columns in the order in which they're displayed in the
grid, followed by any columns that aren't displayed. Note:
Click here
for instructions on determining which columns are displayed in a window.
Optional. If the list of columns is very long, you may want to use the Search Filter Columns feature. Enter part of the column name in the Search field, and click Enter. The list will be shortened to include column names that fit the search criterion. Sample
Click a down arrow to select the field (column name) on which you want to filter.
For date, number, and true/false fields, click a radio button to select one of the filter options.
Select an Operation, if necessary.
Enter values for the criteria as needed.
When finished setting up the filter, click the Apply Filter button. You're returned to the list window with the found records displayed.
If you're not satisfied with the results of the filter and want to edit it, or if you decide you want to save it, click to return to the Filter window, and make the needed changes.
When you're done with the filtered results, click to display all records in the list.
Click here for directions to save the filter for future use.
To create a new filter based on a saved filter, open the filter and edit the filter fields, then select Save As. Name the new filter, change statuses as desired, and click OK.
Return to About Filters