IIF Statement in the Field Box

• hnguye21

  SSC Veteran

  Points: 241

  More actions

  May 29, 2008 at 2:12 pm

  #191622

  Im trying to write an "IIF" statement in the field box where if a fileld value is blank then look at another field value. how do I write that statement.

  for example: IIF(field!number.value =0 then field!letter.value)

  thanks

• Josh B

  SSCrazy

  Points: 2426

  More actions

  May 29, 2008 at 2:29 pm

  #822003

  You could try this...

  IIF(field!.number.value = 0, field!letter.value, field!number.value)

  You'll have to have a true and false option for the IIF statement.