Concatenate Three Fields Here are the steps to Concatenate (combine) the city, state and zip fields for a Mail Merge.   6. Try it: Run the Query The Query is still open in Design View. Place your cursor in Column 6. Right Click->Zoom. Type: CityStateZip:[City]&", "&[State]&" "&[Zip] CityStateZip is the alias, for the new Field. [City], [State] and [Zip] are Fields from tblCustomer. The two quotes have a space between them. Whatever is inside the quotes, say a comma, will be placed between the Fields. The two & signs are the glue that sticks the two Fields together. Click OK. Keep going... Query Tools ->Design Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Manipulate fields: Concatenate (combine) Fields