Microsoft Office Tutorials and References
In Depth Information
Adding calculations with the expression builder
Create an expression with the expression
6 Click in the field, and press Shift+F2 (or right-click and select Zoom).
7 Edit the field title, and click OK.
TIP All fields must have a unique title, even calculated fields
that you create yourself. You can also use this feature to change
a field name to be displayed with an alternative name in a query.
TIP When adding together strings (concatenating the
strings—for example, [First Name] & “ “ & [Last Name]), use the
& rather than a +, because the ‘&’ prevents NULL values from making
the result NULL. The ‘+’ does not do this.