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…