Access Aggregate Calculations
As you worked through the lesson on calculations, you may have thought that the calculation you really wanted to create was a sum of hours
worked on one project for the Projects form.
Unfortunately, displaying aggregate calculations on a form is rather complicated. However you may find that the ease of creating aggregate
calculations on reports with the Report Wizard makes up for that. You might want to try working around the aggregate calculation problem by
creating a query that includes all the data you need on your form as well as a new field that calculates the result you want to display on the
Aggregates, Unique Values, and Top Values
Unlike Access 2010 web databases, web apps do support aggregate queries,
with the familiar aggregate functions you have in client queries.
Not only are they much faster to build and view than equivalent data macros, but you can also use them as sources for data macros.
As you may expect, you still can specify whether a query should return only distinct values or restrict the numbers of rows returned.