UNION Truncates Memo Fields

[Gaston]

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.

 

[Duane Hookom]

A union query will attempt to "group by" unless you specify
SELECT ......
UNION ALL
SELECT ......

 

[Gaston]

Thanks!. The ALL keyword did the trick.

A union query will attempt to "group by" unless you specify
SELECT ......
UNION ALL
SELECT ......