I have a table in Access which contains account numbers. There are many cases where the account numbers are repeated in the database. I need to obtain a count of each unique account numbers in the dataset. Is that possible in a Query.
Sample of the table is attached.