iif

[Guest]

I have the following expression

GGWPERSQFT: IIf(IsNull([SALEPRIC]),[LSPRC]/[APPGSQFT],[SALEPRIC]/[APPGSQFT])

but I want to add:
if [appgsqft] is zero, then null

otherwise IIf(IsNull([SALEPRIC]),[LSPRC]/[APPGSQFT],[SALEPRIC]/[APPGSQFT])

 

[tina]

do it exactly the way you wrote it, as

IIf([appgsqft] = 0, Null,
IIf(IsNull([SALEPRIC]),[LSPRC]/[APPGSQFT],[SALEPRIC]/[APPGSQFT]))

this is a "nested" IIf statement; note the two parentheses at the end.

hth