Hi,
I am trying to deal with 3 Conditions using IIF condition.
Fields that I have CAccomByCo (Check) and CAccomAllw (Integer)
Conditions :
1. If CAccomByCo unchecked And CAccomAllw = 0 Then The Result in Text191 should be 0
2. If CAccomByCo unchecked And CAccomAllw > 0 Then The Result in Text191 should be CAccomAllw
3. If CAccomByCo checked And CAccomAllw = 0 Then The Result in Text191 should be "By Company"
But my code is producing nothing although it has no error.
Can someone help me please....
I am trying to deal with 3 Conditions using IIF condition.
Fields that I have CAccomByCo (Check) and CAccomAllw (Integer)
Conditions :
1. If CAccomByCo unchecked And CAccomAllw = 0 Then The Result in Text191 should be 0
2. If CAccomByCo unchecked And CAccomAllw > 0 Then The Result in Text191 should be CAccomAllw
3. If CAccomByCo checked And CAccomAllw = 0 Then The Result in Text191 should be "By Company"
But my code is producing nothing although it has no error.
Code:
=IIf(IsNull([CAccomByCo] And [CAccomAllw]=0),0,(IIf(IsNull([CAccomByCo] And [CAccomAllw]>0),[CAccomAllw]),"By Company"))
Can someone help me please....