Calculation and check boxes

[Gogargirl]

I bet this is so simple, but I'm just not getting there....

I have a dbase where the records are people. There is a field (Mail) that has 15 check boxes representing criteria I use to select records in order to generate mailing lists. Two of the values "FormerExec" and "FormerFirm" I want to be highly visible if they are checked. So I've created a text calculation field (Former) in 50 pt size that should pick up on this:

Case(Former = "FormerExec", "FormerExec", Former = "FormerFirm", "FormerFirm", "")

It works fine, but only when either of these values are the only ones selected. I can't seem to modify the calc so that it still works regardless of how many of the other values in Former are also checked.

Yours - numbly.....

[andygaunt]

Try this in your calculation.

Case(

PatternCount( Former, "FormerExec"), "FormerExec",

PatternCount( Former, "FormerFirm"), "FormerFirm",

"")

PatternCount looks for a match in a field regardless of all the other text within it.

So as long as that text exists it will return the result.

[ March 07, 2002, 05:40 AM: Message edited by: Andy Gaunt ]

[Gogargirl]

Cheers Andy, works a dream!