Append Query to Delete duplicate records

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Access 2000. I have found instructions on how to delete duplicate records
by creating a copy of a table, changing the primary key and running an
append query. The problem is i need to assign at least 2 primary keys for
it to work for my db. Every field in my database (except the primary key)
can be duplicated and is duplicated in some instances. However 2 specific
fields (Weight) & (TagNumber) are never duplicated together in the same
record.. In other words, (weight) is commonly duplicated, (TagNumber) is
occasionally duplicated, but there is never an instance where these two
fields of the same record are duplicated. How do I have a primary assigned
twice...Thanks..Randy
 
Randy

Based on your description, I don't understand your question - "How do I have
a primary assigned twice". As I read what you've posted, you NEVER have the
multiple fields, taken all together, duplicated.

Or are you asking how to create a composite primary key? Why do you need to
use these fields as a primary key? Do you have any other candidate fields
as keys?

You can, in table design mode, select more than one row and specific them as
a composite (i.e., multi-column) primary key. You could also use the index
screen to set up a multi-column index over the two you mentioned.
 
I guess two primary keys is not what I need, I need a way to delete 540
duplicate records accidently imported. I have one primary key assigned to
an autonumber field. I may have to delete them individually...Thanks..Randy
 
Back
Top