Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / June 2004

Tip: Looking for answers? Try searching our database.

Repost: Union query truncating field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Richard Coutts - 30 Jun 2004 18:25 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.