IIF statement

[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

 

[fredg]

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

 

[Darren]

Your statement is all messed up. Can't even tell what you are trying to do.

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