Calculate Field Results

[MFS]

I have a query that shows . . .


Employee_Clock_Number
Overtime_Hours
Department
Name_Last
Name_First

What I am trying to accomplish in either the same query or a separate query to show how many employees work for each department. (By counting each unique Clock_Number or some other means, it really doesn't matter)

I hope someone can help me.

Speck

[June7]

Build a query that selects DISTINCT Department and Employee_Clock_Number.

Then use that query as source for a GROUP BY that counts the records grouped by Department.

An all-in-one SQL could be like:

SELECT Department, Count(*) FROM (SELECT DISTINCT Employee_Clock_Number, Department FROM table) AS Query1 GROUP BY Department;

[MFS]

Wow!! That works perfectly.
Thank You June7