L
lizardmandy
Guest
Having a bit of trouble with a project, here...
I have a table that includes Employee's Names, Salaries, and Departments
(I also have a Department table, listing each Department)
I need to have a query that will return a listing of each department, the highest salary within the department, and the number of employees working in the department.
The only thing I've been able to do so far is construct a query that prompts the user for the department number, then returns the max salary or the # of employees. I'd like to have all that data in one output when the query is run, without prompting the user to input any values.
Thank you for any advice you might have for me!
I have a table that includes Employee's Names, Salaries, and Departments
(I also have a Department table, listing each Department)
I need to have a query that will return a listing of each department, the highest salary within the department, and the number of employees working in the department.
The only thing I've been able to do so far is construct a query that prompts the user for the department number, then returns the max salary or the # of employees. I'd like to have all that data in one output when the query is run, without prompting the user to input any values.
Thank you for any advice you might have for me!