I'm trying create a query which detects duplicate records,but doesn't delete both or display them in a table.
I want it to delete all but one of the records so I still have one left to use.

Many Thanks