Hello All,
I have a query which returns a vast number of records. Now I want to delete any duplicate record (Leaving the first instance).
I can manually copy this resultant data to excel and delete the duplicates easily by using the Remove Duplicates Option. I want this functionality to be incorporated into my query.
NB: I do not want the records to be deleted from the table.
Any help would be highly appreciated.
Many Thanks
I have a query which returns a vast number of records. Now I want to delete any duplicate record (Leaving the first instance).
I can manually copy this resultant data to excel and delete the duplicates easily by using the Remove Duplicates Option. I want this functionality to be incorporated into my query.
NB: I do not want the records to be deleted from the table.
Any help would be highly appreciated.
Many Thanks