UNION Truncates Memo Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that uses a UNION to put together two queries that contain a
field that has text whose length is greater than 255 characters. The UNION
truncates these to 255 characters. Is this a limitation in Access or a bug?
How can I get around this? Thanks for your help.
 
A union query will attempt to "group by" unless you specify
SELECT ......
UNION ALL
SELECT ......
 
Back
Top