finding duplictes

  • Thread starter Thread starter Dave Cullen
  • Start date Start date
D

Dave Cullen

Is there a way to find duplicate values in one column of a data table? If I
make the column the primary key Access gives an error but won't show me
where the dups are.

Thanks
 
Create a query with this table.

Depress the Total button on the toolbar in query design.
Access adds a Total row to the design grid.

In the Total row under the field that might be the duplicate, choose:
Group By

Add the same field again, in the next column.
Under this one, in the total row choose:
Count
In the Criteria row under this, choose:
1
Click to expand...

The query now shows any values that appear multiple times, and tells you how
many.
 
Back
Top