Queries - Criteria

Criteria are the 'questions' put to the query.  A query is a question set on the underlying table.  You must ask the right questions to obtain the required answer.

• In the query below software which Costs more than R2000 is required.   Note the greater than symbol and the fact that one can leave out the R sign.   After the query has been Run two records meet the required criteria.

Criteria	After the query has been Run

• In the query below software which has a Name beginning with MS is required.  Note the wildcard * at the end of MS.  That indicated that any letters may come after the MS.  After the query has been Run four records meet the required criteria.

Criteria	After the query has been Run

• In the query below software which has the letters afr anywhere in the Name is required.  Note the wildcard before and after the afr.  It means that any letters may precede and come after the letters afr.  After the query has been Run three records meet the required criteria.

Criteria	After the query has been Run

There are many types of criteria, see the list taken from Access itself.

When you have decided on the criteria, one must Run the query.   Click on the Run button to obatin the result of the query.

This work may be freely copied for non-commercial use only. Copyright © Pam Miller