Using Calculated Fields in Tables

If you're new here, you may want to subscribe to my RSS feed. Thanks for visiting!

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

1. Select the table into which you want to create a calculated field.
2. Click the Design View button.
3. Click in the first blank row in the Field Name column and type in a name for your new field.
4. Click in the Data Type column for the field.
5. Click the drop-down arrow in the Data Type column and choose Calculated from the list to display the Expression Builder dialog box.
6. In the Expression Categories column, double-click the name of the first field you want to add to the calculation.
7. Enter any operators such as +, -, / or *.
8. In the Expression Categories column, double-click the name of the second field you want to add to the calculation.
9. Repeat steps 7-8 for any additional fields you want to add to the calculation.
10. 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.

Similar Posts:

• Creating a PivotTable Form in Access
• Create a Parameter Query in Access
• Using Macro Conditions in Access 2010
• Using the AutoSum Button in Excel
• Mail Merge in Word 2007 Part 3: Writing Your Letter
• Creating a Table in Excel
• Creating a Table in Word 2007

Tagged as: Microsoft Office Tips