I am needing to do a distinct query on 2 address fields, add1 & add2 only. There are at one address for instance 4 clients registered to that address - hence the distinct query. But if I do a distinct on all fields it will return all 4 clients from that address.
I then did the below query on the 2 add fields - but cannot figure out how i display a single client name to a unquie address. Any one client name can be used from the address can be used if that helps !
SELECT DISTINCT tbl_Client_Info.Add1, tbl_Client_Info.Add2