Multiple IIf conditions in report
Posted on 2002-05-01
Is it true that you can't tier IIf conditions in Access? This has to be in a report, because it is based on a RunningSum calculation.
Expression I'm trying is below - should be pretty apparent on what I'm trying to do. Any suggestions? Anything that is not .5> is showing up as "CoreB". The other two cases (NonCoreA and NonCoreB)aren't registering.
=IIf(0.5>[% of Total],"CoreA",IIf(0.5<[% of Total]<0.7,"CoreB",IIf(0.7<[% of Total]<0.85,"NonCoreA","NonCoreB")))