title: MS Access query - select most recent date
body: <p>I have a query I'm designing which grabs data from multiple different tables. In MS Access 2010, how would I create one of the query columns so that it returns the <strong>most recent</strong> date out of a series of dates, for each user in the table:</p>
  
  <p>Sample data from table:</p>
  
  <pre>userid: | appointment:
  000001  | 05/10/2009
  000001  | 05/10/2010
  000001  | 05/11/2010
  000002  | 05/12/2009
  000002  | 30/12/2010</pre>
  
  <p>expected output for field query:</p>
  
  <pre>userid:  | appointment:
  000001   | 05/11/2010
  000002   | 30/12/2010</pre>