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?