Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.18 Results of the query
applied to the current Audi and Ford Make condition, and the results are six records
which are shown in Exhibit 4.21.
4.4.4 Advanced Filter
Now, let us consider more sophisticated queries that can be performed with the
Advanced Filter tool. The limitations of Filter are easily overcome with this tool.
For example, the problem experienced above that limited the Make to two entries,
Audi or Ford, can be extended to multiple (more than two) entries. Additionally,
the Advanced Filter tool permits complex searches based on Boolean logic queries
(using AND and OR conditions) that are not possible, or are difﬁcult, with the Filter
The process for creating queries for the Advanced Filter is not much more difﬁ-
cult than the process for Filters . As before, we must identify the database that will
be queried. We must also create a range on the worksheet where we will provide
the criteria used for the query. As usual, a dialogue box will lead you through the
process. We begin by copying the titles of our database and placing them in a range
on the worksheet where we will execute the query. All of the database titles, or some
subset, can be copied. The copy process insures that the titles appear exactly in the
query area as they do in the database. If they are not exactly as they appear in the
titles of the database, the query will not be performed correctly.