>>You can join your table with another table that has only one record, and one memo field.
>>
>>HTH, Hilmar.
>
>
>Thanks Hilmar, I just thought there was a way to do that in one step.
>
>Jim
I suspect there isn't. But of course, you can create the table with memo programmatically. Or you might keep the table-with-memo handy, for several similar SELECT commands.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)