Software

Summarize data by group with a select query in Access

You can use a select query to summarize the data in your Access table by group. Here's how.

Did you know that you can use a select query to summarize the data in your Access table by group? For example, suppose you need to determine the total hours billed by each region using data from your Employee table. Follow these steps:

  1. Create a select query from your employee database that includes two fields: Location and Hours Worked.
  2. In Design View, click the Totals button on the Query Design toolbar.
  3. Under Hours Worked, click the cell in the Totals Row, and choose Sum from the drop-down list.

When you run the query, the results will show the total number of hours worked by region.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

0 comments

Editor's Picks