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