Filtering by Selection


By applying a filter to a datasheet you display a subset of records that meet the filter criteria. Use the Filter by Selection command to show only records that match the data in the field you have selected.



To use the Filter by Selection command:

  1. With the query or table open in Datasheet view, click in the field that contains the value you want to filter for.
  2. Click the Filter by Selection toolbar button.
  3. To show all the records again, click the Remove Filter button.


You don't have to filter by the entire value of the field. You can select only part of the data. For example, if the field you select contains the data rice and beans, you can select only the word rice. Filtering by selection would then return all records that include the word rice in that field.

Use the Filter Excluding Selection command to display all records EXCEPT those that match the selected field value. Click the Records menu, point to Filter, and click Filter Excluding Selection.

To filter by selection:

  1. Click the Filter by Selection toolbar button.
  2. Click the Records menu, point to Filter, and select Filter by Selection.
  3. Click the Records menu, and select Apply Filter/Sort.

To remove the filter:

  1. Click the Remove Filter toolbar button.
  2. Click the Records menu, and select Remove Filter/Sort.