>I didn't read all the messages in the thread but I don't see any reference to a problem with memo fields in your message that started this thread. You certanly can use Memo fileds in a query as long as there is no DISTINCT, UNION or GROUP BY in it.

DISTINCT is my main problem. This - the subject line - came up because of it.

BTW, Thanks for all your help.