Microsoft Office Tutorials and References
In Depth Information
A query based on two joined tables
You should quickly review the criteria you will need to set up this join: If you want data for employees
who are U.S. citizens and who are hourly workers, the Criteria expressions go in the same Criteria row. If
you want data for employees who are U.S. citizens or who are hourly workers, one of the expressions goes in
the second Criteria row (the one with the or: notation).
Now run the query. The output should resemble that in Figure B-18, with the exception of the name
Output of a query based on two joined tables
You do not need to print or save the query output, so return to Design view and close the query. Another
practice query follows.
AT THE KEYBOARD
Suppose you want to see the wages owed to hourly employees for Week 2. You should show the last name, the
employee ID, the salaried status, the week #, and the wages owed. Wages will have to be a calculated field
([Wage Rate] * [Hours]). The criteria are No for Salaried and 2 for the Week #. (This means that another
query is required.) Your query should be set up like the one in Figure B-19.
Query setup for wages owed to hourly employees for Week 2