Filter record with same value

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
 
J

John W. Vinson

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber records inserted in gaps 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
No duplicate records problem 17
Trying to create a report that will list unmatched records by Ticket Primary Key 0
import and other problems 0
How do I record the date of the first record entry. 2
Set Controls Default Value from another Control 4
Relationships 1

Top