Using Aggregate Values in Calculated Fields

To use aggregate values in calculated fields:

1. Click in the first empty cell in the field row of the query grid.
2. Click the Build button.
3. Double-click a total in the center box to add it to the expression box.
4. Build the expression.
5. Click OK.
6. In the Field: row, change the expression title to something meaningful.
7. Change the Total: type to Expression.
8. Click the Run button.

To include the values calculated by aggregate functions in a new calculated field, click in the first empty cell in the field row of the query grid. Click the Expression Builder button. Notice that by default, all of the totals in your query are listed in the middle box. Double-click a total to add it to the expression box. Continue building the expression. When the expression is complete, click OK. Replace the expression title with something meaningful. Finally, change the total type to expression. When you run the query, you'll see the new calculated field for each record group.