Repost: Union query truncating field

[Richard Coutts]

I have two select queries, "qryJobSpecsAlwaysList" and
"qryJobSpecsBySchedCat," that list some fields, including a Memo field
called "Description" that can contain text values that can be 500
characters or more. Both queries work great. Now I need to combine
the two outputs into a single output. So I wrote a simple Union query
that looks like this:

SELECT qryJobSpecsAlwaysList.Description
FROM qryJobSpecsAlwaysList;

UNION SELECT qryJobSpecsBySchedCat.Description
FROM qryJobSpecsBySchedCat;

It lists the proper Memo field "Description" but the text of each
field is getting truncated to 250 characters or so.

Please help!
Rich

 

[John Vinson]

SELECT qryJobSpecsAlwaysList.Description
FROM qryJobSpecsAlwaysList;

UNION SELECT qryJobSpecsBySchedCat.Description
FROM qryJobSpecsBySchedCat;

It lists the proper Memo field "Description" but the text of each
field is getting truncated to 250 characters or so.

Change UNION to UNION ALL and you'll get the full length. What's
happening is that Access is truncating the field to 255 bytes and
using it for grouping to remove duplicates.