iif

  • Thread starter Thread starter Guest
  • Start date Start date
G

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])
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Very Strange: field value is not updated if you try to set it to its default value 1
query with zero records 6
iif statement what is wrong with this expression 2
IIf funtion based on multiple criteria 2
Expressions 1
Issue with IIF[fieldname] is not null statement 12
Division by Zero Error 1
Access Building a IIF expression in Access 0

Back
Top