Learn IT

Question of the week of 7/18/11 – Counting unique records in Access

Question: I’m trying to count only unique records in an Access table and can’t seem to figure it out.

Answer: You need to create a query containing the fields that are duplicated. (If there is just one record with an item in a field that is different that will consider that record unique). Then in the query options (right click in the light gray area of the query) select Properties and change Unique Values to Yes. Then run the query and it should show the unique records, from which you can click the Total button on the Home tab of the ribbon and select Count from the bottom row of the query results screen. We will show this query example in our Queries part 1 class on Thursday, July 21 from 10 a.m. – 12 noon.

Leave a Reply