When you need to perform a very complex search that would require numerous find requests, you can create a single formula.
To match records using a formula:
1 |
If you're not already in Browse or List mode, choose Browse or List from the Layout menu. |
2 |
Choose Show All Records from the Organize menu. |
3 |
Choose Match Records from the Organize menu. |
4 |
Build a formula for your match by selecting fields, operators, and functions. You can also type information in the formula, or paste a formula copied from a spreadsheet or other source. When building a formula: |
|
|
Use logical functions such as AND, OR, and NOT to build formulas with multiple criteria. |
|
Enclose field names in single quotation marks and text constants in double quotation marks. For example, use 'Color'="Blue" to find records with Blue as the value in the Color field. |
|
Construct formulas to evaluate as TRUE for the records you want to select. For example, use 'Color'="Blue" to match records where Blue is the value in the Color field, or 'Color'<>"Blue" to match records where the value in the Color field is any value other than Blue. |
|
For checkbox fields, match the field to a value of TRUE (for selected options) or FALSE (for unselected options). For example, 'Payment Received'=TRUE finds records where the checkbox field Payment Received is selected. |
|
For pop-up menu and radio button fields, use the NUMTOTEXT function to match a field's contents. For example, NUMTOTEXT('Color')="Blue" matches records where the Blue radio button is selected in a radio button field called Color. |
|