Defining Selection Criteria for a Database Tables Query
Note: The options on the Criteria tab for an database
query are different from those for an application query.
To avoid returning long lists of data you don't want, set up criteria that defines the range of data from selected fields that display on the worksheet. All steps in this procedure are performed on the Criteria tab.
Note: Selection criteria behavior depends on the version
of IOS you use. To understand the differences and determine how to
create queries for your version of IOS, see "Assigning Criteria for Database Queries".