Concatenation Business envelopes, letters and customer receipts usually display the First Name and Last Name Fields together. You can use a Query to combine both Fields into one. The command is called concatenation. Here is how it works.   3. Try it: Concatenate Two Name Fields Place your cursor at the top of the next blank Column in the QBE Grid. Type: FullName:[FirstName]&" "&[LastName] Fullname is the label, or alias, for the new field. [FirstName] and [LastName] are Fields from tblCustomer. The two quotes have a space between them. Whatever is inside the quotes will be placed between the fields. The two & signs are the glue that sticks the two fields together. Query Tools ->Design Exam 77-885: Microsoft Access 2010 4. Creating and Managing Queries 4.3. Calculated Fields: Concatenation