Unfair points allocation alert :)
>I think that Sergey's solution is correct, but difficult to extend to more than 3 flags. Try converting the flags to numeric.
>
>
>... where iif(flag_1, 1, 0) + iif(flag_2, 1, 0) + iif(flag_3, 1, 0) >= 2
>
>
>HTH, Hilmar.
>
>>Having a brain cramp.
>>
>>I have a table consisting of:
>>
>>person_id - char(10)
>>flag_1 - logical
>>flag_2 - logical
>>flag_3 - logical
>>
>>
>>I want to do a SQL statment which returns the person_id for any person who has more than 1 of any of the flag fields set to TRUE.
>>
>>
>>select person_id from mytable where flag_1 OR flag_2 OR flag_3 ...but more than one of them....!
>>
>>
>>
>>any ideas? Thanks - Larry
Will Jones