how do i run a distinct count query in access?

A

apple

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top