Microsoft Access 2013 Inside Out

Selecting specific groups

You can also filter groups of totals after the query has calculated the groups. To do this, enter criteria for any field that has a Group By setting, one of the aggregate functions, or an expression using the aggregate functions in its Total row. For example, you might want to know only the employees who had overtime hours within a given time frame. To determine this, open the qryWeekLaborHours query and enter a Criteria setting of >40 for the TotHrs calculated field, as shown in Figure 5-59. Save the query changes, and switch to Datasheet view. The query should now return only two rows in the web app with the sample data in the dates between May 6, 2013, and May 12, 2013.

Figure 5-59. Enter a Criteria setting for the ...