Access 2007

Using Queries - Part 2

Watch the video! (4:45min)

Download the example to work along with the video.

Using totals in a query

Sometimes you may want to see your query results grouped or counted in some way. Access 2007 offers several options to make these functions possible. Perhaps the easiest of these is the Totals command, whose optional functions are similar to the functions used in Microsoft Excel. These functions include:

• Sum, which is used to add a column of numbers
• Average, which is used to find the average of a column of numbers
• Maximum, which returns the highest value in a field
• Minimum, which returns the lowest value in a field
• Count, which is used to count the number of same values in a query

One of the most useful Totals functions to use in queries is the Count function.