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.
Watch the video! (4:45min)
Download the example to work along with the video.
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.