counting records in query

[Vince]

I need to count the # of employees in a query. The problem
is the same EE File # may appear on multiple lines. How do
I count to include the multiple lines as 1, not 5. Thanks

 

[Van T. Dinh]

Use the DISTINCT keyword in your Query.

Check Access / JET SQL Help on "Distinct".

 

[Vince]

Can you give me an example

-----Original Message-----
Use the DISTINCT keyword in your Query.

Check Access / JET SQL Help on "Distinct".

--
HTH
Van T. Dinh
MVP (Access)



Thanks


.

 

[Van T. Dinh]

SELECT DISTINCT [EE File #]
FROM YourTable

Plenty of example in Help and you need to know how to use Help to use Access
efficiently.