Using if to find blank fields?

[newtoAccess]

I am trying to use an iff statment that looks for a blank field. and sets the field to "1"

Find blanks1: IIf([Accredited,Guest,Visitor]=Null,1,0) does not work
Find blanks2: IIf([Accredited,Guest,Visitor]="",1,0) does not work

Any suggestions?

[ser01]

I am trying to use an iff statment that looks for a blank field. and sets the field to "1"

Find blanks1: IIf([Accredited,Guest,Visitor]=Null,1,0) does not work
Find blanks2: IIf([Accredited,Guest,Visitor]="",1,0) does not work

Any suggestions?

Try:

 IIf([Accredited,Guest,Visitor] IsNull,1,0)

[newtoAccess]

Blank_accredited: IIf([Query Make Full name]![Accredited,Guest,Visitor]=[isNull],1,0)

Nope not finding the Null.
It automaticly puts = []

[SteveH2508]

IIf(IsNull([Accredited,Guest,Visitor]),1,0)

[newtoAccess]

yap,,

That works

Thanks again