Combining City and State Errors

[jwrnana]

I have tried the following expressions in my query to combine my city,
state, zip code and country.

=[ShipCity]&[ShipStateOrProvince]&[ShipPostalCode]&[ShipCountry]

In this expression, I get the correct return of data, but without
spaces and commas. If I put spaces and commas, I get just the field names
exactly as typed in the expression.

"[ShipCity]&" "& [ShipStateOrProvince]&" "&[ShipPostalCode]&" "&
[ShipCountry]"

In this expression, I get errors and no return of data.


Any suggestions?

Thank you,
JR

 

[Brendan Reynolds]

=[ShipCity] & ", " & [ShipStateOrProvince] & ", " & [ShipPostalCode] & ", "
& [ShipCountry]

Note the placement of the quotes. Only the literals (spaces and commas in
this example) go inside the quotes, the field names remain outside the
quotes.

 

[jwrnana]

Thank you - that worked!

=[ShipCity] & ", " & [ShipStateOrProvince] & ", " & [ShipPostalCode] & ", "
& [ShipCountry]

Note the placement of the quotes. Only the literals (spaces and commas in
this example) go inside the quotes, the field names remain outside the
quotes.

--
Brendan Reynolds
Access MVP

I have tried the following expressions in my query to combine my city,
state, zip code and country.

=[ShipCity]&[ShipStateOrProvince]&[ShipPostalCode]&[ShipCountry]

In this expression, I get the correct return of data, but without
spaces and commas. If I put spaces and commas, I get just the field names
exactly as typed in the expression.

"[ShipCity]&" "& [ShipStateOrProvince]&" "&[ShipPostalCode]&" "&
[ShipCountry]"

In this expression, I get errors and no return of data.


Any suggestions?

Thank you,
JR