Hello,
I can't seem to find a similar thread on this problem, and would appreciate some assistance.
Importing data to a table each week that can sometimes include duplicate records, I created a duplicate query. It works well to identify those records that are duplicated, but instead of deleting the extra copies and leaving one it proceedes to delete them all.
Any advice? Is there a better technique than the delete query?
Thank you!