G
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!
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!