Delete query

[Jon Parker]

Hi,

I wanted to write a query that identifies duplicate
records based on 2 criteria (i.e. col1="x" AND col2 = "y").

If duplicates are found then all BUT ONE duplicated record
is to be deleted.

Is this feasible, and if so how?

Thank you.

 

[[MVP] S. Clark]

There is no one-query silver bullet that can do this. It will require a
series of steps to perform the match, the determination of which is the Dup
(and which to keep), and finally the actual deletion.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-