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