Exam 77-424: Microsoft Access 2013 3.0 Create Queries 3.3 Utilize Calculated Fields and Grouping Within a Query: Add Calculated Fields (Concatenation)

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