title: MS Access Select the most recent date for each unique Id
body: <p>I am working with MS Access Database.
  I have following table:</p>
  
  <pre><code>Product Id      Date Of Purchase
      A              01-01-2008
      B              01-01-2013
      C              01-01-2012
      A              01-01-2014
      B              01-01-2007
      C              01-01-2011
  </code></pre>
  
  <p>I need to find records for the latest bought products (for all Products)</p>
  
  <p>i.e Desired Output should be:</p>
  
  <pre><code>Product Id      Date Of Purchase
      A              01-01-2014
      B              01-01-2013
      C              01-01-2012
  </code></pre>
  
  <p>I am relatively new to databases. Please help me with the query. Thanks.</p>