Concatenate Two Fields Here are the steps to Concatenate (combine) the first and last names together into one Field.   5. Try it: Concatenate the Name The Query is open in Design View. Place your cursor in Column 6. Right Click->Zoom. 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.   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