Often you do not want to retrieve every row of data from the record that you are accessing. The criteria serve as a test that the system applies to each row of data in the tables that you are querying. If the row passes the test, the system retrieves it; if the row does not pass, the system does not retrieve it.


By defining criteria rows in the query, you:

• Reduce the number of rows of data that are returned.

• Retrieve only the information that you need.


In this topic, you will review selection criteria.

Table of Contents