this might be simple, query writing need help

[icemonster]

how would you go on about writing something like iif([field] = 1 or null,true,false)? thanks. i can't get the part to make it an or

 

[JANR]

How about

IIF(Nz([Field],0)<2,True,False)

Nz() converts Nulls to an alternative value in this case 0

JR

 

[plog]

JAN's solution isn't exactly what you asked for. If [field] actually equals 0 or a negative number it would resolve to True, your initial posting said only the value 1 should resolve to True. The below code will do that:

IIF(Nz([Field],1)=1,True,False)