remove duplicate records from table, leaving one record

[jacqtaylor]

I am trying to remove duplicate records from a table. I have run a query to identify the duplicates. However, I am not sure how to delete the duplicates from my table and leave only one of the records. Contract number is duplicated, but ID # is different.