Discussions

Expand all | Collapse all

Help writing a if statement

  • 1.  Help writing a if statement

    Posted 10-03-2017 21:40
    I have Field one [Type] (text field) and Field 2 [Area] (Related Table numeric: 10,20,30) I have made an additional field [field 3] that I want to show Field 2 unless Field one = Popcorn then Field three to show 40.  

     


  • 2.  RE: Help writing a if statement

    Posted 10-03-2017 22:33
    If([Type]="Popcorn", 40, [Area])