>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, ;
...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up