Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.15 Filter keys in salesperson (Slsprn)
Now let’s query the database to demonstrate the power of Filter . We will begin by
determining which sales occurred on and between 01/01/05 and 01/014/05. Exhibit
4.16 shows the unique data items in the Date pull-down menu as identiﬁed by Excel.
Note that every unique date in the database is represented. There is also a menu
item entitled Custom . This selection will allow you to create a query for a range
of dates rather than a single unique date. By selecting the Custom menu item, you
are permitted numerous logical conditions by which a query can be constructed.
Exhibit 4.17 shows the dialogue box that contains the logical options needed to