Open a table in Datasheet mode and click Filter from the actions bar to reveal the Filter form. This form allows you to find all records that match certain criteria.
A criterion consists of parts where you can specify filtering options:
- Use the first dropdown field to select the column in which to reference the filter.
- Use the second dropdown field to indicate the accuracy on which to search for values.
- Use the last field(s) to enter keywords or values on which to filter the table. The type and number of fields depend on your selections in the first and second dropdown fields.