AnsweredAssumed Answered

While performing a FIND - how can I make a checkbox list pull records from 2 values?

Question asked by dscott23 on Sep 4, 2012
Latest reply on Sep 4, 2012 by comment

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

Don Mattingly

Dick Butkis

Clyde Frazier

 

As always, thanks

Outcomes