Run the Query, Again
The Query
Criteria, is Not Null, should filter out all of the Records that do
not have a Genre.
Did it work?
Only one way to find out: Run it!
4.
Try it: Run the Query
The Query
in still open in Design View.
Go to Query Tools ->Design->Results->Run.
What Do You See? The Query returned 374 out of 401 Records.
All of the Records have a Genre, there are no empties (null).
So, the
Query Criteria worked.
What Else Do You See? The Movies
are sorted by Year. The data is still not complete. Most of the
Movies have a Rating.
Save
your changes and Close the Query.
Let's
create a Report and use this Query for the Record Source.