The question is too general for a specific answer. If you mean that you
want to eliminate just a few duplicate records you can use a Find Duplicates
query. Another way is to copy the table and paste it as Structure Only. In
design view for the new table, hold down the control key and select as many
fields as are needed to assure a unique record, then click the primary key
icon (or Edit > Primary Key). Use an append query to append records from
the old table to the new one. Any records in which there is duplication in
the new multi-field primary key will not be appended. Help has more
information about the various types of queries. If you need more help in
this forum you will need to provide some details.
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.
