sum of a few boolean fields in a query 1

[jamaarneen]

Hi

In my table I have some boolean fields. I would like to create a column in a query, that tells me if there is at least one of the booleans fields that are 'true'.

I tried to write (in query design view) somthing like that:

NewColumnName:= IIf ( ([blField_1]) = -1) Or [blField_2] = -1) Or( [blField_3] = -1)  ; 1;0

I also tried:

NewColumnName:= IIf ( ([blField_1]) = true) Or [blField_2] = true) Or( [blField_3] = true)  ;true;false

but non of these were accepted

I would prefer to get the result as a boolean, but an integer would also be OK.

Thanks for trying to help...

 

[PHV]

Why not simply this ?
NewColumnName: blField_1 Or blField_2 Or blField_3

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jamaarneen]

Great, PHV. As always.

It gives -1 / 0, but it will do it
Thanks