To do a quick filter on a single field, follow these steps:
Go into Table Grid View.
Choose a value in a particular column as the filter value.
Right-click your mouse on the cell that contains the chosen value and select, from the drop-down menu, one of the following:
Filter Using Selection (choose one of the following operators to make a comparison with the current selected cell e.g. if the cell contains 10 and the operator selected is >, then only the records that have a number greater than 10 in this field will be selected)
= Equal
> Greater Than
< Less Than
>= Greater Than or Equal
<= Less Than or Equal
<> Not Equal
Filter Excluding Selection (select only the records that do not include this value in this field/column).
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:
Again right-click your mouse on a value in a particular column (this can be the same column as before or different).
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: