Microsoft Office Tutorials and References
In Depth Information
Filtering to Find Information
Click to lter more than once in the same eld
Enter or select a criterion
You can choose a value on the drop-down list or, in Number and
Currency fields, enter a comparison operator and a value. Table 4-1
explains the comparison operators.
3. If you want, enter more criteria for the filtering operation.
You can enter values in other fields as well as filter more than once in
the same field.
• Enter values in other fields: Open the drop-down list in a field and
enter a comparison value or select a value on the drop-down list.
• Filter more than once in the same field: Select a field in which you
already entered a search criterion. Then click the Or tab and either
enter a comparison value or choose a value from the drop-down list.
When you click the Or tab, the search choices you made previously
disappear from the screen. Don’t worry — Access remembers them
on the Look For tab. You can click the Or tab again if you want to
enter more criteria for Or searching.
4. Click the Toggle Filter button.
The results of the filtering operation appear in the datasheet.