>I don't know of one. I have always kept a dummy table with a blank memo field and just add this to my SELECT statement.

>SELECT table1.fields,,, IIF(EMPTY(table1.notes), dummy.blank, table1.notes) AS notes FROM table1, dummy blah, blah, blah

>you won't need a WHERE condition for the dummy.

Yea, after I posted this question I realized what a DUMMY of a question it was but it was too late to unpost. I goofed. :(