Nested IIF Help

[gretsch]

I am a VB programmer with very limited access reports experiance, how can i make this same IIF statement a nested one? =IIf([IndPTP]>1.25,"Y","N&quot eg:

if the Val is between 1.25 and 1.50 make the result A
if the Val is between 1.51 and 1.75 make the result B
if the Val is between 1.76 and 2.00 make the result C
if the Val is between 2.01 and 2.25 make the result D
if the Val is > 2.26 make the result E.

Not sure how to do this within the Control source of a field in a report..

HELP (again)

 

[GoDawgs]

=IIf([IndPTP]>2.26, E,IIf([IndPTP]>2.01, D,IIf([IndPTP]>1.76, C,IIf([IndPTP]>1.51, B,IIf([IndPTP]>1.25, A, null)))))

That should do it...although I might be missing some parentheses, who knows. Hope that helps.

Kevin

 

[dhookom]

I would not nest the IIf()s since I am old and get confused easily. A clearer solution would use the Switch() function or possibly Choose()
=Choose( ([IndPTP]-1)\.25,"A","B","C","D","E&quot

Duane
MS Access MVP

 

[gretsch]

Bravo Sir! splendid work, go to the top of the class.

Gretsch

 

[GoDawgs]

Did the Choose work? I couldn't get that to work...