Queries can return a large amount of results, and often many of the results are identical For example, if we created a query to see which items have been ordered from our bakery, most of the items will appear multiple times. Sometimes, it’s much more useful to combine the identical items into a sum, average, or count. By creating a totals query, we can quickly see the quantity of each item sold, and avoid getting repetitive results.

If you are interested in learning more about this topic, please visit our site at http://www.gcflearnfree.org/access2010 to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you’ve learned.