IIF Statement in the Field Box

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply