KeepIfAny

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc...]

Description:

Note: Unlike most other statements in MOX, because of the dynamic number of other items you must specify a blank FieldBase when it is not needed and they are not otherwise set by the WorkWith command.

All Records in the Query that have any of the Test values evaluate to True (not blank) will be kept, all others will be discared. Each Test may be a Field name or a literal. When a Field name is used, placing the operator Not with a space in front the Field name will reverse the logic on that item, such that it will be True if blank.