Duplicate records

  • Thread starter Thread starter Sofia
  • Start date Start date
S

Sofia

Hi,
I need help deleteing duplicate inventory records.
Wondering if any one can Help.
Thanks
Sofia
 
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>
 
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
 
Back
Top