By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,938 Members | 1,580 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,938 IT Pros & Developers. It's quick & easy.

Repost: Union query truncating field

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Rich, take a look at ...

http://groups.google.com/groups?hl=e...1c8de20&rnum=2

- Jim

On 30 Jun 2004 10:25:08 -0700, rc*****@comcast.net (Richard Coutts)
wrote:
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.