Apple M9057 User Manual - Page 207

In the Help index,* see: E New Request command E operators Database 8-25 To narrow your search, you can use relational operators (such as < and >), enter values in multiple fields, or require that a record meet either one set of search criteria or another. There are many ways to combine different search methods. The following table provides some common examples. For example, to find Only records that contain a specific value In Find mode, do this in the find request Example Type or select the value. Only records that contain a set of specific values Type or select the set of values. Finds the Italian restaurants Finds the Italian restaurants that have been reviewed All records that contain one or the other set of values Type or select the first value or set of values and then choose New Request from the Edit menu. Enter another value or set of values in the new find request. Finds the Italian restaurants and any restaurant in Calistoga All records that do not Type or ≠ (Option-=) contain a specific value before the value to find records not including empty fields. Or, type or select the value, and then click the Omit box to find all records (including ones with empty fields). Finds all restaurants not in Napa Records with a value less than a specific number Type < before the value. Finds restaurants with average meal prices less than $10 * Choose Index from the or Help menu and scroll to the entry. Then choose a topic from the list and click Go To Topic.