Hi,

I have a value list in a checkbox field. I'm trying to create a calculation that says "if value A is checked, put A here, otherwise leave blank". However, because I'm saying "Field="A"", the value will ONLY show up if it is the ONLY one checked. If multiple values are checked, none of them will show up in their respective calculations. How can I rewrite the calculation so it will pull value A regardless of how many boxes are checked?

Thanks in advance...again,

Leah

If you use either the 'PatternCount( ) or Position( ) functions, you will be able to test whether a particular character or sequence of characters occurs anywhere within a field. Both these functions return Negative/Zero if the search string does not occur anywhere in the text being evaluated.

For example:

Case(PatternCount(YourField, "A"), "A")

will return "A" if there is an A anywhere in YourField, but not otherwise.

Excellent! Thanks,

Leah