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
Jim Allensworth - 30 Jun 2004 19:08 GMT
Rich, take a look at ...
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&th=ce2f9b4f51c8de20&rnum=2
- Jim
>I have two select queries, "qryJobSpecsAlwaysList" and
>"qryJobSpecsBySchedCat," that list some fields, including a Memo field
[quoted text clipped - 14 lines]
>Please help!
>Rich