Select a.[Member ID], a.[Address 1]
From [Mail List] as a
Where (cStr(a.[Member ID]) + a.[Address 1]) =
(Select cStr(Min(b.[Member ID])) + b.[Address 1]
From [Mail List] as b
Where b.[Address 1] = a.[Address 1]
[COLOR=red][B]Group By Address 1[/B][/COLOR]);