Microsoft Office Tutorials and References
In Depth Information
Creating a summary calculation
Creating a summary calculation
A summary query can be used to perform different summary
calculations on your data. It supports the calculation of Sum,
Max, Min, Avg, and other calculations.
Group By values and group the data by that column. You can
also change the Total row to Where, when you want to filter the
data, or to a calculation such as Avg.
After you have changed your query into a summary query, any
new columns added to the query are displayed as the default
1
Add a summary
1 Click the Totals button.
2 Use Group By to group your results; you can add multiple fields.
3 Choose summary calculations.
4
Filter the records to summarize by using the Where selection.
2
3
4
TIP You can put criteria against a Group By column to filter
results, but it is more efficient to use the Where syntax because
this applies the filter criteria to the records that go into the summary
calculation. All other criteria are applied after the calculations have
been performed, to restrict the displayed result.
Search JabSto ::




Custom Search