A filter is used to determine which records that are displayed in the browse list, and makes it possible to work with a subset of the database (for example, programs purchased a specific year). You define a filter the same way you define a search criteria.

If you use both the grouping feature and filter feature, the filter and grouping are combined in the filtering process.

The Filters drop-down list above the grid indicates which filter that is currently active.

If you cannot see the Filters drop-down list, choose Lists -> Layouts/Sort Orders/Filters from the View menu.

You can create a simple or advanced filter. To select the type of filter to create when you choose Add Filter, right-click the Filters drop-down list and choose either Simple Filter or Advanced Filter from the popup menu.

Simply select a filter from this drop-down list to change the active filter. Right-click the drop-down list to display a popup menu with more options:

To simply filter on one of the field values displayed in the browse list, right-click the value you want to filter on and select Quick Filter from the popup menu. For more information, see To use the Quick Filter function.