IFF Between...And

  • Thread starter Thread starter John Drake
  • Start date Start date
J

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
 
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
 
Back
Top