IFF Between...And

[John Drake]

Hi

I have a text box in a form and in the CONTROL SOURCE of this text box I
want to use an IFF function that evaluates a number.

The field is in one table and the fieled is called Results.

The problem is that I have to do this for the if the
value <200, "something1", or if the
value is between 200 and 250, "something2", or if the
value is between 260 and 350, "something3", or if the
value between 360 and 450, "something4", or if the
value is between 460 and 600, "something5", or if the
value is between 610 and 910, "something6", or if the
value is >910, "something7".

To compound the problem even further is that I am a NEWBIE - sorry.

Thanks

 

[John Spencer]

IIF(Results <200, "XXX",
IIF(Results <=250, "YYY",
IIF(Results <=350, "ZZZ",
IIF(Results <=450, "YYY",
IIF(Results <=600, "YYY",
IIF(Results <=910, "YYY",
IIF(Results >910, "YYY")))))))


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[John Drake]

Hi Mr Spencer.

Thanks for the help . . . . . it worked.

Regards
John