Add a calculated field to a table

In Access, you can create table fields that calculate values, somewhat like using a formula in Excel. The calculations can include values from fields in the same table as well as built-in Access functions.

Notes: 

  • The calculation cannot include fields from other tables or queries.

  • The results of the calculation are read-only.

In this article

Create a calculated field

Modify a calculated field

Create a calculated field

  1. Open the table by double-clicking it in the Navigation Pane.

  2. Under Tools, click Add Field.

  3. Type the Field Name, and choose Calculated in the Data Type column.

    Access displays the Expression Builder.

  4. Begin typing the calculation that you want for this field. For example:

    [Quantity] * [Unit Price]

    Note:  It is not necessary to precede the expression with an equal sign (=).

  5. Click OK.

    Access adds the calculated field, and then highlights the field header so that you can type a field name.

  6. Type a name for the calculated field, and then press ENTER.

Top of Page

Modify a calculated field

  1. Open the table by double-clicking it in the Navigation Pane.

  2. Click on the calculated field that you want to modify.

  3. Click the ellipses () on the Expression line in the Field Properties box.

    Access displays the Expression Builder.

  4. Make the necessary modifications to the calculation.

    Note:  It is not necessary to precede the expression with an equal sign (=).

  5. Click OK.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×