Using Queries to Make Data Meaningful - Part 2

In Access queries let you retrieve information from one or more tables on a set of defined search conditions. Learn how to use queries in Access here.

Using queries: Part 2

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:

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