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

Oh that is good to know! Yes, that will cut out a step or two now and in
future.

I appreciate the follow up on this!


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, July 12, 2011 8:02 AM
To: accessd at databaseadvisors.com
Subject: Re: [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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com