5 Replies Latest reply on Sep 4, 2012 7:36 AM by comment

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

    dscott23

      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