UNION Truncates Memo Fields

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.
 
D

Duane Hookom

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

Guest

Thanks!. The ALL keyword did the trick.

Duane Hookom said:
A union query will attempt to "group by" unless you specify
SELECT ......
UNION ALL
SELECT ......
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make Table Query Truncating Memo Field at 255 Characters 2
Union query changes Memo to Text (256 char limit) 1
Union query truncates data 9
Query Truncating Memo Field 9
Access 2003 truncates code in queries 3
Union All Query bombs report 2
Query Truncates Field Data 4
Query Truncating Memo Field Question #2 1

Top