title: access select distinct on certain column
body: <p>I have a table with some search results. The search results maybe repeated because each result may be found using a different metric. I want to then query this table select only the distinct results using the ID column. So to summarize I have a table with an ID column but the IDs may be repeated and I want to select only one of each ID with MS Access SQL, how should I go about doing this? </p>
  
  <p>Ok I have some more info after trying a couple of the suggestions. The Mins, and Maxes won't work because the column they are operating on cannot be shown. I get an error like   <code>You tried to execute a query that does not include the specified expression...</code> I now have all my data sorted, here is what it looks like </p>
  
  <pre><code>ID|Description|searchScore
  97     test        1  
  97     test        .95
  120    ball        .94
  97     test        .8
  120    ball        .7
  </code></pre>
  
  <p>so the problem is that since the rows were put into the table using different search criteria I have duplicated rows with different scores. What I want to do is select only one of each <code>ID</code> sorted by the <code>searchScore</code> descending. Any ideas? </p>