>How do you remove duplicates in a table? Can this be done without using a second table?
See my FAQ #8129 about some discussion on this topic. Also see DupCheck class in Download section here. Is it a one field or concatenation of fields?
If it's not broken, fix it until it is.
My Blog 
