HELP WITH DELETE QUERY IN ACCESS

H

harish

I have one table of records (SKUProfile). I have a query which is a
subset of the table and provides a list of all the duplicate records in
the table.

I need to delete the Duplicates from the Original Table, so that I can
append another query to the main table whcih contains only the
consolidated data.
 
T

Tom Ellison

Dear Harish:

Please provide details. Start with the SQL of the query you are using.

When you say "delete the Duplicates" I expect you mean to leave one out of a
set of duplicate rows. Are these rows duplicate in EVERY column, or only
certain columns? Assuming you want to leave one of these rows, how do you
specify which one?

Tom Ellison
 
Top