I have a field named City. I also have a field named Income. I need to find records from people in New York & Chicago who make less than $20,000
I created a checkbox list based on the actual values in the City field (as thedata in that field is inconsistant (NY & New York, LA & Los Angeles)
If I do a FIND and check off more than one city value, the search returns zero records as it is looking for BOTH values in the one field instead of finding all values in multiple records.
In the attached sample the search should return 3 records
As always, thanks