Filter Query

D

DandimLee

Is there a way to filter for records that have one of two values. I have two
Yes/No fields, and they can't both be True. I want the records that have one
or the other. The way I have it now, the records that have one or the other
are grouped on top, but after those records, the records that have neither
appear in the form.
 
S

Synapsys

Given Field1 and Field2, both yes/no, I'd put "<>Field1" under Field2
or visa versa. This will return only records where the two fields are
unequal.

Todd
 
O

Ofer Cohen

The True value is -1 and making that as positive you van use it as the filter
(the False return 0)

Try

Select * From TableName Where Abs(nz([YesNoField1],0)) +
Abs(Nz([YesNoField1],0)) = 1
 
Top