Count uniques with other fields in the query

[Guest]

Hello,
I have been trying everything. What I want to do is run a query on one
table that counts the unique occurances of Emp #. also, I want to group by
month, week, or day. I pasted in some code that I found...however it is not
working. Please help with some basic code that will allow me to count unique
occurances of a field.

Examples:
Total - 45 unique Emp #
Mar - 15 unique Emp #
Apr - 19 unique Emp #
Week 1 - 22 unique Emp #

Thanks for the help!

 

[Darren]

Use a subquery...

ex:

Select Count(Empno), mo, Empno from
(
Select Distinct EmpNo, Month([SomeDateField]) as Mo
Where ....
)
Group By Mo, empno