Access 2010 now allows you to create calculated fields in tables. Previously, you could only create calculated expressions on the fly with queries, forms and reports. With the new Calculated data type, you can now create calculations directly in your tables.
To Create a Calculated Field in a Tables
- Select the table into which you want to create a calculated field.
- Click the Design View button.
- Click in the first blank row in the Field Name column and type in a name for your new field.
- Click in the Data Type column for the field.
- Click the drop-down arrow in the Data Type column and choose Calculated from the list to display the Expression Builder dialog box.
- In the Expression Categories column, double-click the name of the first field you want to add to the calculation.
- Enter any operators such as +, -, / or *.
- In the Expression Categories column, double-click the name of the second field you want to add to the calculation.
- Repeat steps 7-8 for any additional fields you want to add to the calculation.
- When finished, click OK.
Tip: To create a calculated field in Datasheet View, click in the first blank column, and click the contextual Fields tab on the Ribbon. Then, click the More Fields button on the Ribbon, point to Calculated Field, choose the data type for the fields from the menu and then create your expression.