Aggregating Data

On an inquiry form, you may need to display an aggregated value for a group of records, such as an average value for a group of records or the number of records in a group. In this chapter, you will learn how to add an aggregation clause to a data query that is used to determine the records listed on a form.