>My client has a report and wants to translate a user defined code into a description on the report. Currently she has a IIF(loan_type == '1', 'Construction', IIF(loan_type == '2', 'Line of Credit', IIF(loan_type == '3' .... etc. She now has so many loan_types that the Express Builder's Express of Field on Report, scrolling text box is at the maximum. How else can she accomplish her code translation?
>
>Brenda

If you have translation table, you can prepare cursor for this report with description included (use left join to the Translation table).