plz explain how to use iif in msaccess

[pabbiraj]

Actually, what i want to know, I have two text boxes, i.e.text1, text2. text1 contains numeric data i.e., 12,215,300,0.56....and text2 contained i.e ">=200","<=200","<10%".... I want to use the formula like this..if the text1 data is fallen in text2, then show as "Pass" else "Fail"..Plz see the data like this..

Text1 Text2 Result
12 >=200 Fail
215 <=200 Fail
150 >=100 Pass

just like the data should come and the result column should show the result.

[RayMilhon]

The IIF Syntax is IIF(Evaluation part,Truepart,Falsepart) so IIF(1=1,"TRUE","FALSE") would display TRUE IIF(1=2,"TRUE","FALSE") would display FALSE. However, I have never attempted to use it where you would append 1 textbox to another text box to get the Evaluation part. I have no clue not only to how it would work but if it would work.

[orange]

Try Google for Ms Access functions - techonthenet has most

http://www.techonthenet.com/access/f...vanced/iif.php