how do i run a distinct count query in access?

[Guest]

I have a table that lists account numbers, cycle dates, and other supporting
information. The composite key is made up of 3 different fields. I'd like
to run a query that counts the distinct number of account numbers (they can
show up multiple times) but I'm having trouble. Normally I'd use a simple
"select count (distinct acct_nbr) from table" in SQL but this command doesn't
seem to work in access.

Any ideas??

 

[Lynn Trapp]

Try this instead:

SELECT Distinct Count(Acct_nbr)
FROM YourTable;

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html