title: Delete duplicate records based on timestamps
body: <p>I have a table tblCost which contains:  </p>
  
  <pre><code>RecordID    ProjectID    Cost    AllocationMonthYear    TimeStamp    
  112            1         $1000       10/17              10/16/2017 12:09:53 PM 
  113            1         $1200       11/17              10/16/2017 01:14:45 PM 
  114            1         $1000       10/17              10/16/2017 02:21:23 PM
  </code></pre>
  
  <p>AllocationMonthYear is the month for which the budget is allocated. My problem is that the software is located on a shared drive and used by multiple users. They often add duplicate record for the same month. I need a query to delete the duplicate record based on the latest timestamp, i.e, record 114 ought to be deleted because it is a duplicate of 112 and is LATER than 112.<br>
  Any pointers highly appreciated</p>