Microsoft Office Tutorials and References
In Depth Information
• Click the OK button to ﬁ lter the
records (Figure 3–17). (Your order
may be different.)
Can I use the same technique in
In Form view, you would need to
click the ﬁ eld and then click the
Filter button to display the
Common Filter menu. The rest of
the process would be the same.
only clients whose
city begins with
Ber are included
• Click the Toggle Filter button on
the Home tab to toggle the ﬁ lter
and redisplay all records.
To Use Filter By Form
Filter By Selection is a quick and easy way to ﬁ lter by the value in a single ﬁ eld. For more complex criteria,
however, it is not appropriate. For example, if you determined you only wanted those clients whose postal code is
80330 and whose amount paid is 0, you could not use either the Filter by Selection or the Common Filter processes.
Rather, you would use Filter By Form . The following steps use Filter By Form to restrict the records that appear.
• Click the Advanced button on the
Home tab to display the Advanced
menu (Figure 3–18).
Clear All Filters
Filter By Form