Prev: Auto set height of vertical line to height of detail section
Next: Report Detail - How do I either anchor Lines or box
From: John Drake on 8 Jul 2008 11:27
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
 | 
Pages: 1
Prev: Auto set height of vertical line to height of detail section
Next: Report Detail - How do I either anchor Lines or box