count occurrences

[Guest]

I have a table with multiple occurrences of an account numbers. The
occurences have different dates. Account no is in one column and date is in
another column. I wouls like to be able to "count" the no of account numbers
but not total number of times they occur. In other words, if account 1 is
listed 3 times and account 2 is listed 4 times, I would only like to return
"2" as the number of accounts that are in the table.

 

[Jeff Boyce]

Create a new query. Add the table. Add the Account# field.

Modify the properties to return only Unique Values.

The number of records returned when you run this query is the number of
(unique) Account numbers.

Regards

Jeff Boyce
Microsoft Office/Access MVP