graphic1

Exam 77-424: Microsoft Access 2013
3.0 Create Queries
3.2 Modify a Query : Modify a Query (Edit Criteria)

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

graphic2