Edit a calculated field in PivotTable view

Microsoft Office Access 2003

  • Open a datasheet or form in PivotTable view.
  • Select the calculated field whose expression you want to edit.
  • On the PivotTable toolbar, click Properties Button image, and then click the Calculation tab.
  • Edit the expression, and then click Change.

    The data values will be automatically recalculated using the new expression.

  • ShowTip

    To add field references, select a field that you want to use from the Insert Reference To box, and then click the Insert Reference To button.