Combining 3 columns into one in a access query

Question

I have inserted a column into design view of my query. How do I combine three separate columns into one. I need to get the City, State and Zip into my new column?

Answer 1

with the question i can only suggest this.

SELECT [Field1] & ", " & [Field2], " & [Field3] FROM DesiredTable;