Microsoft Office Tutorials and References
In Depth Information
Filtering a Datasheet
In some cases, a filter isn’t the best tool for the job. If you’re looking for the
top or bottom values in a field or for unique or duplicate values, you need to
use a query. Also, if you want to use the same filter repeatedly, creating and
saving a query is likely to be a better solution for you.
Understanding filtering basics
If you want to get a handle on the whole filtering concept, start by taking a
look at the parts of a datasheet that relate to filters. To begin, you can
display the filter menu for any field by clicking the arrow next to the field name.
To see what common filters are provided, choose the item above all the
check boxes (in Figure 3-2, Number Filters). To filter to a particular value,
use the check boxes, as we discuss shortly.
You can apply a filter to any datasheet, including a table, of course, but also
to subdatasheets and datasheets generated by queries. (When you apply a
filter to a subdatasheet, all the data displayed from the subdatasheet table
is filtered, not just the record where you apply the filter.) You can enter and
edit data in a filtered datasheet as usual. Just be aware that the filter has no
effect on any new records until you reapply the filter.