Microsoft Office Tutorials and References
In Depth Information
Filtering Data Lists
If you want to filter records in which only a particular field entry matches,
exceeds, falls below, or simply is not the same as the one you enter in the
text box, you then click OK or press Enter to apply this filter to the database.
However, you can use the Custom AutoFilter dialog box to filter the database
to records with field entries that fall within a range of values or meet either
one of two criteria.
To set up a range of values, you select the “is greater than” or “is greater than
or equal to” operator for the top operator and then enter or select the lowest
(or first) value in the range. Then, make sure that the And option is selected,
select “is less than” or “is less than or equal to” as the bottom operator, and
enter the highest (or last) value in the range.
Check out Figures 11-8 and 11-9 to see how I filter the records in the
Employee Data List so that only those records where Salary amounts are
between $25,000 and $75,000 are displayed. As shown in Figure 11-8, you set
up this range of values as the filter by selecting “is greater than or equal to”
as the operator and 25,000 as the lower value of the range. Then, with the
And option selected, you select “is less than or equal to” as the operator and
75,000 as the upper value of the range. The results of applying this filter to
the Employee Data List are shown in Figure 11-9.