title: select most recent record if theres a duplicate
body: <p>So i have been scratching my head over this one,mostly because i am on access 2010 and most of the queries i have found on the internet have commands that do not work on access. </p>
  
  <pre><code>id    name    date        qty       created
  ====================================================
  1     abc     01/2016     20        06/07/2016 11:00
  2     abc     02/2016     20        06/07/2016 11:00
  3     abc     03/2016     20        06/07/2016 11:00
  4     abc     01/2016     30        06/07/2016 13:00
  </code></pre>
  
  <p>I need to pull out a recordset like this:</p>
  
  <pre><code>id    name    date        qty       created
  ====================================================
  2     abc     02/2016     20        06/07/2016 11:00
  3     abc     03/2016     20        06/07/2016 11:00
  4     abc     01/2016     30        06/07/2016 13:00
  </code></pre>
  
  <p>the created field is just a timestamp, the date field is a "due date". basically i need to pull out the most recent qty for each name and date. the ID is unique so i can use it instead,if its easier. 
  By far i've got: </p>
  
  <pre><code>SELECT m1.date, m1.name, m1.created
  FROM table AS m1 LEFT JOIN table AS m2 ON (m1.created &lt; m2.created) AND 
  (m1.date = m2.date)
  WHERE m2.created IS NULL;
  </code></pre>
  
  <p>but this one gives me only the most recent conflicted data, ie. the record n°4 in my example.i also need the other two records. any thoughts?</p>