>Hi Naomi,
>
>Finally figured it out. If the select statement has a memo field in it, you can not use the distinct keyword. But the results are still fairly distinct.
>
>Thanks for you help.
>Beth
>
I'm glad you had it sorted. You may mark your own message as a solution now.
>>Ok, try both selects without the first part before UNION. I think for these two select statements they are not needed. Also you may want to try to simplify these selects (or start building them from simplest to complex) until you find the offending piece. Right now it's still hard for me to figure out what the problem may be.
If it's not broken, fix it until it is.
My Blog