If validates that c_ordrcode exists. If it doesn't, c_ordrcode will return "U".
>IIF(TYPE("c_ordrcode")="C",c_ordrcode,o_rec_id)
>
>Thanks alot John. I know how IIF() statements work, but I don't understand how that one works. What does TYPE("c_ordrcode")="C" do?
>
>Thanks
>
>BK
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05