Use this procedure to create a calculated field.
To create a new calculated field:
-
On the Tools tab, click
Calculated Fields.
-
In the
Display For list of the Calculated Fields dialog box, select the table for which you want to create a calculated field.
-
Click
New.
-
In the New Calculated Field dialog box, take the following actions:
- In the
Name field, enter a name for the new calculated field.
- In the
Applies to Table list, select a table to which the calculated field should be added.
- In the
Data Type list, select the type of data to be returned by the calculated field. The data type of the field must match the result produced by the calculated field expression.
-
Click
OK to continue.
-
In the Calculated Field Expression dialog box, enter the expression for the calculated field.
The
Fields and Functions buttons display dialog boxes that provide standard lists of fields and functions you can use to help you build the expression.
-
When you have finished entering the calculated field expression, click
OK.
-
When the Calculated Fields dialog box is redisplayed, click
Close.