IIf Statement - Above 55 = AT = 40-54 = OT and Below 39 = BT 2

[lmn]

Why is this statement wrong?

Expr1: IIf([Score]>=55,&quot;AT&quot;,&quot;&quot Or ([Score] Between 40 And 54,&quot;OT&quot;,&quot;&quot Or ([Score]<40,&quot;BT&quot;,&quot;&quot


I'm trying - in one column - to determine if a score is Above Target, On Target or Below Target. I thought this would work....

Any suggestions on what I'm doing wrong?

 

[dannyocean]

They must be nested

Expr1: IIf([Score]>=55,&quot;AT&quot;,&quot;&quot Or ([Score] Between 40 And 54,&quot;OT&quot;,&quot;&quot Or ([Score]<40,&quot;BT&quot;,&quot;&quot

Try this solution


Expr1: IIf([Score]>=55,&quot;AT&quot;,IIF([Score] Between 40 And 54,&quot;OT&quot;,IIF([Score]<40,&quot;BT&quot;,&quot;&quot))

 

[lmn]

Genius - thanks.

If I knew how to give stars I'd give you one (and the Trendsetter dude who has helped me out of many a pickle)......

 

[WildHare]

Here's a perhaps easier way to handle this kind of thing:

MyScore: Switch( Score >= 55, &quot;Above Target&quot;, Score < 40 , &quot;Below Target&quot;, True, &quot;On Target&quot


I have an aversion to nested IFs - unless you like spaghetti.

JMH


Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[KornGeek]

To give stars, click on

Mark this post as a helpful/expert
post