You can use the XOR Boolean operator to combine two Boolean clauses and return TRUE if one of the clauses is true--but false is both or neither are true. If you require the opposite result use the EQV operator inside your formula.

That is, use EQV if you want records that meet both or neither criteria, but do not want records that meet one or the other criteria.

TRUE Eqv TRUE returns a value of TRUE
FALSE Eqv TRUE returns a value of FALSE
TRUE Eqv FALSE returns a value of FALSE
FALSE Eqv FALSE returns a value of TRUE

This article is copyrighted by Crystalkeen, Mindconnection, and Chelsea Technologies Ltd. It may be freely copied and distributed as long as the original copyright is displayed and no modifications are made to this material. Extracts are permitted. The names Crystal Reports and Seagate Info are trademarks owned by Business Objects.