quick question - find unique

[lemonap618]

Hello All,
I hope this finds everyone well!
I need help using finding the number of unique employee numbers the query designer to create a query that returns the unique employee numbers. Can someone help me here? I'm trying to learn the basics of Access. Thanks!

[pbaldy]

Can't look at the sample right now, but in SQL view try

SELECT DISTINCT FieldName FROM TableName

Using your names.

[mike60smart]

Hi

Your File needs to be in Zipped format

[Micron]

create a query that returns the unique employee numbers.

SELECT DISTINCT Payroll.empno FROM Payroll;

You should not be storing net pay, and your table should have a primary key, even if it's only an autonumber.
Edit
I removed Group By as originally was trying to show just the total, then remembered you want the unique values.

[CJ_London]

finding the number of unique employee numbers

query would be

SELECT count(*) FROM (SELECT DISTINCT Payroll.empno FROM Payroll)