I need to find records that contain a phrase in one of many fields that also contain another phrase in another set of fields.
See attached layout. There are two sets of fields in question. 1) RATING fields (1 through 11) and 2) TYPERATING fields (pictured as 1 through 5 but in reality is 1 through 99).
I need to run a find like the following.
Find all records that:
Contain "HEL" in ANY of the RATING fields
Contain "LR-JET" in ANY of the TYPERATING fields
Note that the phrases are not an exact match but are partial phrases. The "HEL" search could return records with fields containing "A/HEL", "C/HEL", or "P/HEL" and should all be included in the find.