How do I remove duplicate records based on criteria?

[Guest]

I am trying to remove duplicates from a table using a two part primary key.
I want to choose which record to keep based on a third column. I want to
choose based on the max create date for the records

 

[Guest]

I'm not sure about this two part primary key, but you can use the duplicate
query wizard to find any duplicate records (you can specify which fields to
check for duplicates) and then delete all of the older records through the
query.

 

[Guest]

Try the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=209183