Memo field in a Union query

[Joe Heym]

Here's another strange one I've just discovered. Any advise would be much appreciated.

I am using a Union query to bring two datasets together, one of the fields is a Memo datatype. In the result of the Union the Memo field is truncated to just 255 characters. Is there any way I can get around this?

Thanks


Joe

[XLGibbs]

Try making it a UNION ALL query instead of just UNION UNION will de-dupe and truncate memo fields, but the UNION ALL should bypass that truncation.