Access 2016 Intermediate

Access 2016

Lesson 4 – Designing Advanced Queries

concatenation character (the ampersand & ) appears between field names, and you must enclose any additional characters in double quotes. For example, the expression Names: [Last Name]&", "&[First Name] concatenates the Last Name and First Name fields and inserts the concatenated text string into a field called Names . The new field displays the last name, a comma, a space, and the first name for each record in the table.

Creating a concatenation expression

NOTE Use concatenation to create text strings in forms and reports. To use the Expression Builder to concatenate text, select any blank Field row and click the Builder button on the Design tab.



Procedures

1. Open the desired query in Design view. 2. Select any blank Field row in the design grid. 3. Type the desired concatenation expression. 4. Press [Enter] .

OFFICEPRO, Inc.

Page 83