title: How to get only one row for each distinct value in the column?
body: <p>I have a question about Access.If for example I have a table with the following data :</p>
  
  <pre><code>  NAME         | ADDRESS
    John Taylor  | 33 Dundas Ave.
    John Taylor  | 55 Shane Ave.
    John Taylor  | 786 Edward St.
    Ted Charles  | 785 Bloor St.
    Ted Charles  | 90 New York Ave.
  </code></pre>
  
  <p>I want to get one record for each person no matter of the address.For example :</p>
  
  <pre><code>  NAME        | ADDRESS
    John Taylor | 33 Dundas Ave.
    Ted Charles | 90 New York Ave.
  </code></pre>
  
  <p>Can this be done with queries only ?
  I tried using DISTINCT, but when I am selecting both columns, the combination is allways unique so I get all the rows.</p>
  
  <p>Thank you !</p>