Part V: Analyzing Data with Excel
692
Figure 33.14 shows how the query for the example presented earlier in this chapter appears in
Query. Recall that the goal is to retrieve records in which all of the following applies:l (^) The Division is N. America.
l The Department is Training.
l (^) The Category is Compensation.
l The Year is 2009.
l (^) The Month is Jan, Feb, or Mar.
FIGURE 33.14
Add the fields and criteria to complete your query.
Tip
Double-clicking a criteria box to display the Edit Criteria dialog box enables you to select an operator
and value. n
Using multiple database tables
The example in this chapter uses only one database table. Some databases, however, use multiple
tables. These databases are relational databases because a common field links the tables. Query lets
you use any number of tables in your queries.