Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

with the question i can only suggest this.

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

share|improve this answer
this solve your problem??? if yes, please Mark this question as answered. Just click on check image in the left of this post. – Mak Mar 31 '10 at 15:32

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.