IIF statement

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I use iif statements all of the time but never with more than 1 criteria. I
need to build a statement with a couple of conditions. Here is what my code
looks like:
iif(([Total Sales 2003]),0 and ([Total Sales 2004]),<>0,([Sales % Chg]) =
100%) I just can't seem to get this to work.................Help.

Thanks,
Chris
 
I use iif statements all of the time but never with more than 1 criteria. I
need to build a statement with a couple of conditions. Here is what my code
looks like:
iif(([Total Sales 2003]),0 and ([Total Sales 2004]),<>0,([Sales % Chg]) =
100%) I just can't seem to get this to work.................Help.

Thanks,
Chris
Click to expand...

I have no idea what you are trying to do.
Here is generic use of IIf with an AND operator.

=IIf([FieldA] = SomeCriteria and [FieldB] =
OtherCriteria,TruePortion,FalsePortion)
 
Your statement is all messed up. Can't even tell what you are trying to do.

Syntax: IIF(Condition, True Result, False Result)
 
Back
Top