s Access Aggregate Calculations | Design-Create Access Forms and Data Manipulation
DBWebApplications 





Access Data Manipulation  «Prev 

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 form.


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.