How can I combine the following table fields to look like such in a query?
I have tried this in excel as well as a query in access and no success for four days now..
tbl_City_State_Zip
City State Zip
Raleigh NC 29706
Raleigh NC 29707
Raleigh NC 29708
Raleigh NC 29709
Query output would be:
Raleigh NC 29706 29707 29708 29709,