>>Thank you so much! I tried it and it bombed big time. :-)
>>
>>No fault of yours of course. The code does not account for NULL values. I went in the table that had the null fields and took them out. It all worked fine then.
>>
>>How would I account for NULL values in this code?

>SELECT ;
>  IIF(ISNULL(A.NullFld), "", A.NullFld) AS NoNulls, ;
>  ...

Actually, it'd probably be better to use NVL(), as inL

SELECT NVL(a.nullfield,''), ;