Filtering out specific text from a field
I have a field containing a value list with six text options. The field is expressed as a checkbox set, and multiple options can be chosen at one time. I want to be able to tell when any single one of those options is chosen, even when others are chosen at the same time.
In other words, I am looking for an operator that would look to see if a field "contained" specific text, but not necessarily exactly equal to a specific line of text (because it may have more than one selection from the value list chosen). The calculation (using the Case function) works just fine when only one of the items on the value list is chosen, but stops working when more than one is chosen.
After searching this forum and going through my manual multiple times, I can't seem to find an answer. Any help would be greatly appreciated.