9 Replies Latest reply: Jul 7, 2015 11:46 PM by Jim Chan RSS

    How to use the IF statement to exclude some un-wanted data in a field?

    Jim Chan

      Hello there,

       

      I have a table name called alpha with data A,B,C,D . and B,C is unwanted data and i want my listbox to display only A,B.

       

      so in the expression i wrote - if(alpha <> 'B' & 'C',alpha)

       

      But it is not working. and correct me?

       

      Rgds,

       

      Jim