how do i run a distinct count query in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
Back
Top