Filtering on a single field

To do a quick filter on a single field, follow these steps:

  1. Go into Table Grid View.

  2. Choose a value in a particular column as the filter value.

  3. Right-click your mouse on the cell that contains the chosen value and select, from the drop-down menu, one of the following:

= Equal

> Greater Than

< Less Than

>= Greater Than or Equal

<= Less Than or Equal

<> Not Equal

The table will be redrawn to show only those records allowed by the filter.

Another filter can be applied on top of the first one:

  1. Again right-click your mouse on a value in a particular column (this can be the same column as before or different).

  2. Select either Filter Using Selection or Filter Excluding Selection.

You can apply as many filters as you like, each being applied to the records remaining on view after the application of the previous filter.

To clear a filter or succession of filters, right-click anywhere within the table and select Remove Filter from the drop-down menu (alternatively, click on the arrow in the Filter box and select Filter - None from the drop-down list). Closing the table will also clear all filters.

Note: The Filter box on the Query toolbar indicates that the filter is Filter - Untitled. This is the name given to any temporary filters you apply to your table and is redefined for each temporary filter or succession of filters you apply.

If you want to re-apply a filter you can save it as a named filter, which can then be used as many times as you wish.

See:

Filtering using a named filter