Matching records using a formula

    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.

Related topics

 


Table of contents | Index