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

Hi Bill

But you are missing the obvious - the DISTINCT is not needed if you use UNION and not UNION ALL.

If you don't need memo fields, certainly don't use them. If you have the need (for holding text beyond 256 chars) you may in your UNION or DISTINCT query use:

  LEFT(YourMemoField, 256) 

/gustav