>I am looking for a good routine to find duplicate records in my tables. Most I have seen use one field that they can depend on to be unique. We all know in the real world there is no such thing unless you create it when you are adding the data and then still you can be adding a duplicate and giving it a unique key. Any ideas?
Randall,
What exactly is your problem? Did you look at the recent FAQ "Eliminating Duplicates". If you need combination of field to be unique, just change code to use this combination...
See, if the FAQ would help, if not, ask a more direct question, please.
If it's not broken, fix it until it is.
My Blog