Audio CaptionStartStop

Adding a Calculated Field to a Query

To enter formulas in calculated fields:

  1. Open the query in Design view.
  2. Click the field where you want to add the calculated field.
  3. Type the name of the new field, followed by a colon.
  4. Enter the expression to be calculated.
  5. Run the query by clicking the Run button.

To create a calculated field, open the query in Design view. Type the name of the new field followed by a colon. Then type the expression to be calculated. Here, the expression references field names, which must be enclosed in brackets. Run the query to see the calculated results in your new field.