There has to be an easier way to do this aside from doing it manually.
See, I have a table with like 150k records in it and there are tonnes of duplicates that will take days to delete and filter manually.
Wondering if someone can come up with a re-useable routine that will allow me to delete large quantities of duplicate records in varying tables. I am comfortable with copying and pasting vba and modifying variables to suit a certain situation if this helps.
I've enclosed a sample of the problem in the db attachment.
Any help appreciated.