Deduplication Query help

[pmonaghan]

Hi,



I need help deleting duplicate records from a table.
The table contains details about email, such as sender, recepient, subject, sent date etc etc. I would like to delete records where the sender, subject and from fields match.
I have an ms access generated unique ID field.
The duplicates there because my central table has been amalgomated from several different sub tables. I queried a search term on the central table get the current table I am working on. There are just under 1000 records.
If possible I would like to delete certain data sets before others but this is not essential.


In summary, if all of the three from, subject and sender selected fields match, I would like to delete the duplicate records. I would like to delete on a priority basis based on what table the record comes from (shown in another field).

Can anyone help with this?

I am pretty new to access so go easy on me!

Pete

[help_me_with_access]

not difficult. Actually I think Paul has a sample method on his site here: http://www.baldyweb.com/. It might be somewhere there.

the query wizard in access also identifies duplicate records for you. try it and see the sql it produces. it'll ask you what you need to know. million ways to do this, but easiest for you without learning anything new might be just to let access show you what's duplicated, copy 1 of each record to a new table, then delete everything in the query that access produced. then copy your new non-duplicated records back into your original table.

Ahhhh....the stuff you can do to get things done by mixing software programs! I still remember the day that I used visual basic's extensibility DLL to write PHP code in an access table so I could paste it directly into Dreamweaver and upload. Heck, that was even better than using a 3rd party service!