title: Finding nearest date to today in Access 2013
body: <p>My query returns results similar to this. </p>
  
  <pre><code>id        date
  510010    12/09/2013
  510010    10/09/2013
  510010    05/09/2013
  510010    14/09/2013
  510012    14/09/2013
  510012    10/09/2013
  </code></pre>
  
  <p>Is there a way that I can make my query only select the date nearest todays date for each distinct id?</p>
  
  <p>Expected outcome.</p>
  
  <pre><code>510010    12/09/2013
  510010    10/09/2013
  510012    10/09/2013
  </code></pre>
  
  <p>Thanks, 
  Chris </p>