What is the value of a Yes/No box?

[mariaw]

Hi

I want a query to generate a "1" if someone ticks the Yes/No box, and a "0" if they do not.

This doesn't work: Expr2: IIf(IsNull([Q2(i)]),"0","1")

and neither does this:Expr1: IIf([Q2(i)]="Yes","1","0")

????

Arrhh

ta

 

[RichO]

A Yes/No control can have one of 4 values (if not null).

True or -1 (same thing)

False or 0 (same thing)

If you want it to return a 1 for yes and a 0 for no (or null):

Abs(Nz(SomeField))