finding duplictes

[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

 

[Allen Browne]

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

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