How do I Use IIf() with the Operator in a String

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PABBIRAJ
    New Member
    • May 2012
    • 1

    #1

    How do I Use IIf() with the Operator in a String

    i have 2 fields. Text1 and text2. Text1 is num field and text2 is text field. How to use iif. The data is like this..in text1 (22,335,69,85,6 3) and in text2 ("<=50",">=350" ,"<=75%"">=80%" ). I want show in the result as "P" or "F".
  • TheSmileyCoder
    Recognized Expert Moderator Top Contributor
    • Dec 2009
    • 2322

    #2
    You can use Eval to calculate string expressions. Imagine you have a control on your form, called tbEval and you set its controlsource to:
    Code:
    =Iif(Eval(text1 & text2);"P","F")

    Comment

    Working...