Repost: Union query truncating field

  • Thread starter Thread starter Richard Coutts
  • Start date Start date
R

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
 
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.
Click to expand...

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.
 
Back
Top