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

The best syntax is:

hlduep = IIF(newuep = 0, paycalc.unemp_ins_pct, newuep)