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, with no ugly gaps between short and long names.

 

Save this query as CustomerNameSQ.