Writing and IIf statement in Access?
Roger,
There are 2 problems. One is that you are missing the last part of your 2nd
conditional statment. The second is that you appear to be testingfor more
than 2 conditions.
Based on what you have written, try this:
field name: = IIf([PT1]=0,[PC1]-[IC1],[PT1]-[IC1])
You only need the aditional IIf statement if you are testing for a 3rd
condition:
field name: = IIf([PT1]=0,[PC1]-[IC1],IIf([PT1]0,[PT1]-[IC1],[XX1]-[IC1]))
Just remember that there are 3 parts: 1) the condition you are testing for
2) value if true 3) value if false false
"Roger Drews" wrote:
I am trying to write an IIf statement to use in a calculation where if PT1 is
zero it will use PC1 to determine the value. Here is the state I have tired
but I cannot get it to work. What am I doing wrong?
IIf([PT1]=0, [PC1]-[IC1], IIf([PT1]0,[PT1]-IC1])
|