How do I identify duplicates?

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

Guest

I have a simple table with name, address type of info. I am getting large
numbers of rows to deal with so I want a systematic way of identifying when I
may have duplicates. I am using the last name field only right now. I tried
DISTINCT and it returns just what DISTINCT promises but not what I want. I
tried NOT DISTINCT but received a syntax error. What I want returned are all
rows that have another with the same last name. Thanks.
 
Create a query into this table.

Depress the Total icon on the toolbar (upper sigma icon).
Access adds a Total row to the grid.

Drag the LastName field into the grid.
Accept Group By under this field in the Total row.

Drag the primary key into the grid.
In the Total row, choose Count.
In the Criteria, enter > 1

The query returns the last names and the count of each.

You may want to drag the primary key into the grid two more times.
In the Total row under the first choose: Min.
Under the 2nd, choose: Max.
These give you the first and last primary key of the matches, which will
help you to find the duplicates.
 
Back
Top