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

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