graphic2
graphic1

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

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

 

pic1