>>Hi all,
>>
>>Could someone please enlighten me. I have a select statement that seems to work fine however when I added a DISTINCT to it, it gave the error "invalid for a Memo, General, or Picture field." I do have memo fields in my select statement, so I guess I can't use the distinct clause?
>>
>>Is there a good alternative?
>>
>>Thanks in advance.
>
>You can use GROUP BY on the rest of the fields but not on those type of fields.

Thanks that's what I was coming around to.