IIF And

[gheyman]

I have a expression with one IsNull

IIf(IsNull([DivisionName]),[CorporateName],[CorporateName] & ", " & [DivisionName]&", "[DivisionLocation])

what if I wanted to say "if" DivisionName And CorporateName where Null, how would that expression be written?

 

[Joe4]

It would start...

[COLOR=#333333]IIf(IsNull([DivisionName]) And [/COLOR][COLOR=#333333]IsNull([[/COLOR][COLOR=#333333]CorporateName]),...

[/COLOR]

 

[gheyman]

For the If statement, if I wanted it to return a blank/null if the Isnull is true, is it the same as Excel ""?

 

[Joe4]

It depends on what you need. In Access, blank and null are not the same.
"" would return blank
Null would return a Null value.