Query Criteria

Suppose we only wanted to see the movies that were released in 2005. Take the query back to Design View. Let’s add Criteria to the fourth row in the Movie column. Criteria are words, phrases or numbers that filter the records in the table.

 

Try it: Edit the Query Criteria

Select the Year column

Click on Criteria

Type: “2005”

Run your query.

 

What do you see? Your query should find 32 movies released in 2005 in your database. Please go back to the Design View and test the query with 2004, or 2003 in the criteria.

 

Boolean operators  mean And, Or. Try this:

Select the Field for Year.

Add a Criteria: "2005"

Type in or: "2004"

 

When you run the query, do you get all of the movies in the year 2004 OR 2005?