duplicate deletion?

[sdkramer]

I used the wizard to make a query for duplicates but there is quite a great deal of them, and I would like to delete all but one entry so that the following table:

itema
itemb
itemc
itemc
itemd
itemb
iteme

would be reduced to:

itema
itemb
itemc
itemd
iteme

Is there any way I can modify my current query to delete and keep at least one version of the duplicates.

Thanks

 

[Pat Hartman]

No. The easiest way to do this is to create a copy of your current table with a primary dey defined that will not permit duplicates. You can include up to 10 columns if necessary.

Then create an append query that copies the rows from your existing table and appends them to the new table. The first instance of each set will be added to the new table and the others will be discarded. Just click OK at the end to accept the partial append.