Create a New Calculated Field

Use this procedure to create a calculated field.

To create a new calculated field:

  1. On the Tools tab, click Calculated Fields.
  2. In the Display For list of the Calculated Fields dialog box, select the table for which you want to create a calculated field.
  3. Click New.
  4. 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.
  5. Click OK to continue.
  6. 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.
  7. When you have finished entering the calculated field expression, click OK.
  8. When the Calculated Fields dialog box is redisplayed, click Close.