[AccessD] Select Distinct not working on union query - due to MEMOfield?

DISTINCT considers every field in your query.

Susan H.


>I was using Select distinct on records from a subquery which itself was the
> result of a union query. To my mind, Select distinct should produce the 
> same
> result in such a situation as a group by query using the same fields. The
> Group By query condensed the records, however, and the select distinct 
> query
> did not. I chased down the reason to this:  One of the fields was a memo
> field.
>
> I don't know if the takeaway here is
>
> (1) Use Group By queries instead of Select Distinct, whenever possible
> (2) Don't use MEMO fields whenever possible
> (3) I have not really discerned the real reason for the difference and am
> fooling myself.
>