A
Allen
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;
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;