Error 3075 Missing Operator

[KLynch0803]

I keep getting a Missing operator error in access 2007



Error 3075: Syntax Error (missing operator) in query expression '[citystate] - abbeville LA'

To me it appears that I'm not grabbing the first variable in the comparison but I'm just not sure where my error is.. Can someone please show me what i got wrong?

Here is my query sql code

 
SELECT query2.citystate, ConcatRelated("zipcode","query2","[citystate] = " & [citystate])
FROM query2;

Here is where I found help on the function I'm trying to perform..
http://allenbrowne.com/func-concat.html

[RuralGuy]

Try:

SELECT query2.citystate, _
ConcatRelated("zipcode","query2","[citystate] = '" & [citystate] & "'" ) _
FROM query2;

[KLynch0803]

Try:

SELECT query2.citystate, _
ConcatRelated("zipcode","query2","[citystate] = '" & [citystate] & "'" ) _
FROM query2;

TY for the reply RuralGuy...

Unfortunately I'm still getting Syntax error in query expression ConcatRelated("zipcode","query2","[citystate] = '" & [citystate] & "'" ) _

[RuralGuy]

Is the CityState field a string or numeric field? Try renaming your bound control to txtCityState and then change the SQL to:
SELECT query2.citystate, ConcatRelated("zipcode","query2","[citystate] = '" & Me.txtcitystate & "'")
FROM query2;

[KLynch0803]

Is the CityState field a string or numeric field? Try renaming your bound control to txtCityState and then change the SQL to:
SELECT query2.citystate, ConcatRelated("zipcode","query2","[citystate] = '" & Me.txtcitystate & "'")
FROM query2;

It may be easier if you are seeing exactly what I'm trying to do..

I have attached a sample db of mine.
I'm trying to take tbl_city_zip and find all unique city/state's and concatrelated zipcode into a value in a query as such

Raleigh NC 27615 27614 27613
Cary NC 27564 276565 27566
so on and so on

Therefore I would only hae the city state listed once and all related zip codes on the end of it as one row...

I was using query2 to create my list of city state values to add the related zipcode to.

[RuralGuy]

This one works but there are some issues you will need to deal with.