How to get only one row for each distinct value in the column ?
- by Chavdar
Hi Everybody,
I have a question about Access.If for example I have a table with the following data :
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.
I want to get one record for each person no matter of the address.For example :
NAME | ADDRESS
John Taylor | 33 Dundas Ave.
Ted Charles | 90 New York Ave.
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.
Thank you !