0

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?

1 Answers1

1

with the question i can only suggest this.

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

Mak
  • 184
  • 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