Filtering a table

Filtering is a way of selecting records from (or creating subsets of) a database table, according to values that you specify for certain fields. The filter can be either a simple filter on a single field or a more complex filter on several fields at once. You can save and name complex filters for future use.

Moreover, you can fine tune a named filter to apply conditions before selecting the records. Since any filter applied to a table is undone when the table is closed, you can save a named filter as a Filter and re-apply it whenever you choose.

See:

Filtering on a single field

Filtering using a named filter