Access 2010

To create a totals query:

1. Create or open a query you would like to use as a totals query. For our example, we want to find the total number we've sold of each of our menu items, so we'll use a query showing us all of the menu items we've sold. If you want to follow along in our database, open the Menu Items Ordered query.
2. In the Query Design tab, locate the Show/Hide group, then select the Totals command.
   The Totals Command
3. A row will be added to the table in the Design Grid, with all values in that row set to Group By. Select the cell in the Total: row of the field you would like to perform a calculation on, and click the drop-down arrow that appears.
   Selecting the totals row of the field we want to perform a calculation on
4. Select the calculation you would like to be performed in that field. In our example, we want to add the quantities of products we've sold, so we'll select the Sum option.
   Setting the Totals calculation to Sum
5. When you are satisfied with your query design, select the Run command on the Query Tools Design tab to run the query.
   The Run Query command
6. The query results will be displayed in the query's Datasheet View, which looks like a table. If desired, save your query by clicking the Save command in the Quick Access Toolbar. When prompted to name it, type in the desired name, then click OK.
   Saving the totals query. Note the sums in the far-right field.