Edit the Query Criteria

This Report is supposed to Group and Total on the Genre. We can add a Criteria to the Genre Field that filters out all of the ones have a no value: they are Null.

 

Before You Begin: Change the View

Go to Home->View->Views.

Select a View: Design View.

 

3. Try it: Edit the Query Criteria

Go to the Genre Criteria.

Type: Is Not Null

 

Keep going...

Home->View->Views->Design View

Exam 77-885: Microsoft Access 2010

4. Creating and Managing Queries

4.3. Manipulate fields: Use Criteria to Filter Records