Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

You must log in to answer this question.