O'Reilly logo

Microsoft Access 2013 Inside Out by Jeff Conrad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required