Microsoft Office Tutorials and References
In Depth Information
AT THE KEYBOARD
As another example of a Totals query, suppose you want to know the average wage rate of employees,
grouped by whether the employees are salaried. Figure B-27 shows how to set up your query.
Query setup for average wage rate of employees
When you run the query, your output should resemble that in Figure B-28.
Output of query for average wage rate of employees
Recall the convention that salaried workers are assigned zero dollars an hour. Suppose you want to
eliminate the output line for zero dollars an hour because only hourly-rate workers matter for the query. The
query setup is shown in Figure B-29.
Query setup for nonsalaried workers only