>can use this:
>
>iif(newuep = 0,hlduep = paycalc.unemp_ins_pct,hlduep = newuep)
>
>instead of this:
>
>if newuep = 0
> hlduep = paycalc.unemp_ins_pct &&writeback unemployeed insure %
>else
> hlduep = newuep &&writeback unemployeed insure %
>endif
>
>
>will the iif set the values or is iif only used for returning a true and false value.
But what you *could* do is
hlduep = IIF(newuep=0,paycalc.unemp_ins_pct,newuep)