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
Brent Knight
Progressive Impressions International
Bloomington, IL
Wise men talk because they have something to say; fools, because they have to say something.
-Plato