 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / March 2006Problem with memo field in query
Hello all. I'm fairly new to Access and am having a problem with a query. The query pulls data from multiple fields. One of these fields is of type memo. In this field are 500 chars (approx). For some reason when i run the query it pulls only the first 255 chars from the field and omits the rest. The strange part here is that when i make a small test query only pulling the data from this problem field it returns the correct data. However when its part of the larger query it only pulls the first 255 chars. Can anyone suggest why this may be happening or give me some ideas to try? Thanks for reading people, its apprecaited. Do a search and read the previous posts on this exact question. This is a pretty common question. Look for "truncating memo" as your search string.  SignatureRick B > Hello all. I'm fairly new to Access and am having a problem with a query. > [quoted text clipped - 9 lines] > > Thanks for reading people, its apprecaited. If that doesn't answer your question. POST the SQL of the query that is not working the way you wish. Please identify which field is the memo field. (Possibly unneeded instructions follow) Open the query Select View:Sql from the Menu Select all the text Copy it Paste it into the message > Do a search and read the previous posts on this exact question. This is a > pretty common question. Look for "truncating memo" as your search string. [quoted text clipped - 16 lines] >> >> Thanks for reading people, its apprecaited. >The query pulls data from multiple fields. One of these fields is of type >memo. In this field are 500 chars (approx). For some reason when i run the >query it pulls only the first 255 chars from the field and omits the rest. This usually happens when you Sort or Group by the memo field. Access won't attempt to sort records on the basis of a memo field (which, after all, could be over a gigabyte in size) so it truncates it. John W. Vinson[MVP] |
Reply to this Message |
 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.