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, and this is how we do it:

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.