Removal of Duplicates

J

James O

Hey All,

Here is my problem. I have a table with about 33000 records, around 4000 of
them are duplicates. I want to run a delete query that will get rid of the
duplicates. There is a Date, Volume and Dollar amount category. Thanks for
any help that you can offer!

Hizaed
 
J

John Vinson

Hey All,

Here is my problem. I have a table with about 33000 records, around 4000 of
them are duplicates. I want to run a delete query that will get rid of the
duplicates. There is a Date, Volume and Dollar amount category. Thanks for
any help that you can offer!

Hizaed
Click to expand...

One convenient and quick way is to create a new table by copying this
one, design mode only. Open the new table in design view and create a
unique Index on the set of fields which constitute a duplicate (e.g.
by ctrl-clicking Date, Volume and Dollar and the Key icon to make them
a joint three-field primary key; or use the Indexes icon and create
one unique index on these three fields).

Run an Append query from your current table into this one. You'll get
a warning message "4000 records were not added due to key violations"
- that's your duplicates.

John W. Vinson[MVP]
 
Top