Refining Queries  «Prev  Next»

Creating a Totals query

For further practice, try this on your own in Access, using another instance.
You can post what you have learned in the discussion area. Let's review the correct steps to take:
  1. From a standard select query, you will make it into a Totals query that sums up the hours for each project. To start, click the Totals toolbar button.
  2. Now you can see the new Total row in the lower half of the query grid. For the Hours column, click the Total row entry, which is currently Group By.
  3. From the list of aggregate functions displayed, click Sum.
  4. Run the query. Click the View button to display the results.