counting records in query

  • Thread starter Thread starter Vince
  • Start date Start date
V

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


.
Click to expand...
 
SELECT DISTINCT [EE File #]
FROM YourTable

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