Check Boxes Select more than one?

[corey]

I am using a Calc. Field that has 4 x Check Boxes.

I can get it to work if 1 x selection is made, but i want to be able to select a combination of 2 Check Boxes.

How do i do this?

Am using :-

CASE(fielda="a",fieldz,

fielda="b",fieldy,

fielda="c",fieldx)

I tried this:=

CASE(fielda="a" and "b",fieldzz)

and

CASE(fielda="a and b",fieldzz)

but they did not work.

Where can i ADD the AND to include a selection of 2 x check boxes into the calc.?

any help appreciated

corey....

[QuinTech]

Hi, Corey. Instead of using "and", use the paragraph symbol. FM uses that to delimit checkbox choices. However, it is also order-dependent; that is, if you click A then B, your field contents will be "AB", but if you clicked B first and then A, the field contents would be "BA".

So you're better off using PatternCount:

Case(PatternCount(fielda,"A") and PatternCount(fielda,"B"),fieldzz)

HTH,

Jerry