Create a calculated field by using a function

1. Add a field that contains the values you want to total.

   How?

2. Click anywhere in the field you want to total, and then click Cycle through Totals .
3. Continue to click Cycle through Totals until Microsoft Query displays the type of total you want.

   Each time you click Cycle through Totals, Microsoft Query calculates and displays a different type of total (the function used is indicated in the column heading). To see a description of the functions you can use to create totals in a calculated field, click .

4. After you select the function that generates the type of total you want, click Query Now to display the results of the calculated field.

Notes

• To remove a calculation from a field, click Cycle through Totals until the column heading contains the original field name.
• If your query contains many records, you can save time by waiting to display the results of the calculated field until you select the function you want. Make sure the Auto Query button is not pressed in.