You enter the expression in the Field cell in the query design grid. The fields you reference in the expression are from the tables or queries in the current query.
| Expression | Description |
|---|
| FullName: [FirstName] & " " & [LastName] |
Displays the value of the FirstName and LastName fields, separated by a space, in the FullName field. |
| Address2: [City] & " " & [Region] & " " & [PostalCode] | Displays the value of the City, Region, and PostalCode fields, separated by spaces, in the Address2 field. |
| ProductInitial: Left([ProductName], 1) | Uses the Left function to display in the ProductInitial field the first character of the value in the ProductName field. |
| TypeCode: Right([AssetCode], 2) | Uses the Right function to display in the TypeCode field the last two characters of the value in the AssetCode field. |
| AreaCode: Mid([Phone],2,3) | Uses the Mid function to display in the AreaCode field the three characters starting with the second character of the value in the Phone field. |