String Functions in a Query

[Mschneider331]

I need to create a query using a customers table that will display the city, state and zip code on one line in a format that is standard on envelopes. I must use a sting function.

Example:

Los Angeles, CA 90501




Can anyone help me I'm trying to research online but I'm having trouble finding instructions.

[pbaldy]

This is flagged as solved; is it? If not, you can concatenate:

City & ", " & State & " " & Zip

using your field names of course.