i have a record with multiple cities, i am trying to add a field and but all
the cities in one filed . What i have so far only repeats the city???

ID    Name                   City    All_cities
53    Bobby Brown    Atlanta    Atlanta Atlanta
53    Bobby Brown    New York    New York New York
53    Bobby Brown    Louisville    Louisville Louisville
53    Bobby Brown    Miami    Miami Miami

SELECT Table1.ID, [First] & " " & [Last] AS Name, Table1.City, [City] & " "
& [City] AS All_cities
FROM Table1;