What are some of the criteria I can set or use in my Query in Access 2007? The criteria is the parameters you set on what you want to view in your Query. For example, if you want pull up all the products that are greater then say $2,000.00. Then in the Query go to the Product's Price field column and click in it's Criteria field and type >2000. This means greater than 2000. Then when you run your query you should only see the price's of products that are greater then $2,000.00. There are many criteria codes you can use to filter your records, and be used in combination too! Watch our Access 2007 training videos and see how easy it is to set your criteria!

Purchase the training video and you can see this in action for yourself!