Duplicate records

[Sofia]

Hi,
I need help deleteing duplicate inventory records.
Wondering if any one can Help.
Thanks
Sofia

 

[Jeff Boyce]

Have you looked into the query wizard for identifying duplicates?

Are your records "duplicates" as a computer would decide, or as a human
would?

Jeff Boyce
<Access MVP>

 

[Deuce Sapp]

I found a neat trick in the help file. Copy your table and paste it as a
copy with the structure only. Modify the design of the copy to create a
primary key for your serial number or part number or whatever.

Now, create an append query where it appends all of the records in your
original table to your copy. It will reject all of the duplicates!

Hope that helps.


Deuce