how to find the min, max and avg salary for each dept. in query?

H

Hallowed

I have an employee database and I wish to find the min, max and average
salary for EACH department.

How do I achieve this ?
 
V

Vincent Johns

Hallowed said:
I have an employee database and I wish to find the min, max and average
salary for EACH department.

How do I achieve this ?
Click to expand...

Via a "Group By" field with the department's identifier.

I suspect that there is more to this question. For example, do you ALSO
want min, max, &c., statistics for the entire organization, and for some
intermediate levels? Or is something else involved that's not obvious?

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
M

Marshall Barton

Hallowed said:
I have an employee database and I wish to find the min, max and average
salary for EACH department.
Click to expand...


Use a Totals type query. Create a new query and add the
table. Then use the View - Totals menu item to display the
Totals row in the query design grid.

Drag the department field down to the field list and make
sure the Totals cell fo the field is Group By.

Now, drag the salary field to the field list three times.
Set the Totals cell to Min, Max and Avg respectively.

Run the query yo see if you're getting the desired results.
 
Top