Change the aggregate function of a calculated control

1. Open the data access page in Design view.
2. Double-click the calculated control whose function you want to change.
3. On the Data tab, in the TotalType property box, select a function from the list.

Notes

• When you change the aggregate function of a control, the default alias and caption of the control change to reflect the underlying aggregate function. To prevent the control name from changing, type a new alias for the control in its ControlSource property. User-specified aliases don't change when the aggregate function is changed.
• Changing the aggregate function of a control does not affect other aggregate controls, such as those that calculate subtotals or grand totals.