Filter record with same value

  • Thread starter Thread starter rahmad
  • Start date Start date
R

rahmad

Hi All,
I have A problem with my table.
I imported about 5000 record into my database table
from excel.I choose a field called 'Item No' as a primary
key,but it seem there are some record have similar 'Item No'
value.I don't know which record has duplicate values.
How to sort the record so that I can see all records with
similar 'Item No' and consider which one to be deleted.

thank's
 
Hi All,
I have A problem with my table.
I imported about 5000 record into my database table
from excel.I choose a field called 'Item No' as a primary
key,but it seem there are some record have similar 'Item No'
value.I don't know which record has duplicate values.
How to sort the record so that I can see all records with
similar 'Item No' and consider which one to be deleted.

thank's
Click to expand...

Use the New Query button, and choose the "Find Duplicates" query wizard.

John W. Vinson [MVP]
 
Back
Top