More Concatenations 5. Try it: More Concatenations If you wanted to display Last Name, First Name your concatenation would look like this: LastNameFirst:[LastName]&", "&[FirstName] Another useful concatenation is: CityStateZip:[City]&", "&[State]&" "&[Zip] Now, when you create a report or mail merge, the fields will be evenly spaced, without ugly gaps between short and long names.   Enter these examples into the Query. Keep going... Query Tools ->Design Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Calculated Fields: Concatenation