How to use Xor in a query

[aziz rasul]

Does anyone know to use the Xor logical operator in a query?

 

[Pat Hartman]

The easiest way is to use the QBE grid to create the query as you would for an AND condition. Then switch to SQL view and change the AND to XOR. When you switch back to QBE view, you'll see the correct syntax for coding the XOR there.

 

[aziz rasul]

Thanks Pat.