How to Access Query Totals

You can use Access databases when you need to work with large volumes of data. Access offers several flexible options when you need to manipulate your data. Your Access queries extract information out of your database. Specify the table or query fields that you want displayed in the query by using the query design view. When the query is executed, the results are displayed in the datasheet view. Use the Home tab to add totals to your query.

• 1

  Open Access 2010, click the "File" tab and select a database from the recently used databases in the "File" menu. The database opens.

• 2

  Locate a query in your Navigation Pane. Double-click the query name to execute it. The query results are displayed in the datasheet view.

• 3

  Click "Home" and select "Totals" from the Records group. A Totals field appears at the end of your query results. Click in the field where the total will be displayed. Notice a drop-down list appears. Select "Sum." Your query total is displayed.