Question that need to be solved: We need a function who can remove duplicates from lists based on a specified field.
To be clear..
* Let say we have a database with 100000 rows, companys.
* Some of those companys has been imported twice or more.
* Filter out all except those duplicates based on a specific field (f.e. "CorpID" a textfield who only takes integers as input mask).
We want to be able to delete (and count) every duplicates except one.
* It would be excellent if there is possible to control what duplicate to keep (f.e. keep the duplicate with last date in XX field).
This question is based on http://www.experts-exchange.com/Databases/MS_Access/Q_22034007.html
who was solved with excellence.