Constract of Multiple Fields

[KLynch0803]

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,

[llkhoutx]

That's not normally what a query does.

Run a query grouping on city state; Then cycle through that query's recordset in DAO or ADO VBA concantenating the various zipcodes.

[KLynch0803]

That's not normally what a query does.

Run a query grouping on city state; Then cycle through that query's recordset in DAO or ADO VBA concantenating the various zipcodes.

Im not sure how to do that exactly (obviously to my own self being lost)

I do have a query that exists that just gives me the City and States list which is qry_City_State.

How would I write the DAO to cancantenate the rest so its all in one field?

[llkhoutx]

Giving you the code would be beyond your obvious comprehension and do you a great disservice.

Get you a good Hornbook on the subject. I recommend the O'Reilly publication, Access Databases, 3rd Edition. Any of the earlier editions would be too ok.

[KLynch0803]

Giving you the code would be beyond your obvious comprehension and do you a great disservice.

Get you a good Hornbook on the subject. I recommend the O'Reilly publication, Access Databases, 3rd Edition. Any of the earlier editions would be too ok.

Ok why couldnt I use something like this in a sql query?

 
SELECT tbl_City_zip.[City]+' '+Concat([city],[state], [zip]"city='" & city & "'") AS result
FROM tbl_city_zip
GROUP BY tbl_city_zip.[city];

[llkhoutx]

By definition queries aren't generally used to combine data on different rows.

Trying building a crosstab query with zipcodes as columns and city state as row, then query that query combining all the zipcode columns in one column with city state. Depending on the number of zipcodes, this may not be practical.

[dcrake]

Access does not recognise the Concat Function as far as I a am aware

here is a link http://www.mvps.org/access/modules/mdl0004.htm to an example of what you are looking for.