If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Memo Field data truncated in query
TIA:
I have a multi-table query; a child table has a memo field with lots of text. A multi-table query with parent and child table fields with no criteria returns the ALL of the memo data. If any criteria is set for fields other than the memo field, the query returns the memo data truncated at 255 characters!!! Access 2002, searched knowledge base and found nothing specific to this issue. Other issues about 255ch truncation. Anyone know about this issue? Any fix?? Some other setting causing the truncation?? Thanks!!!! Joel |
#2
|
|||
|
|||
Memo Field data truncated in query
Several possible causes. The most common is that your query is performing
some kind of aggregation which includes the memo field, e.g. if the query contains a GROUP BY clause that includes the memo field, or if there is a DISTINCT in the predicate. If that does not give you a useful lead, post the SQL statement from the query (by selecting SQL View from the view menu in query design). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Joel" wrote in message ... TIA: I have a multi-table query; a child table has a memo field with lots of text. A multi-table query with parent and child table fields with no criteria returns the ALL of the memo data. If any criteria is set for fields other than the memo field, the query returns the memo data truncated at 255 characters!!! Access 2002, searched knowledge base and found nothing specific to this issue. Other issues about 255ch truncation. Anyone know about this issue? Any fix?? Some other setting causing the truncation?? Thanks!!!! Joel |
#3
|
|||
|
|||
Memo Field data truncated in query
Alan:
Thanks, I have the unique values set to yes which creates the Distinct SQL clause. Is this true with all databases or just Access to limit Group By or Distinct Memo data to 255 characters? Thanks, Joel -----Original Message----- Several possible causes. The most common is that your query is performing some kind of aggregation which includes the memo field, e.g. if the query contains a GROUP BY clause that includes the memo field, or if there is a DISTINCT in the predicate. If that does not give you a useful lead, post the SQL statement from the query (by selecting SQL View from the view menu in query design). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Joel" wrote in message ... TIA: I have a multi-table query; a child table has a memo field with lots of text. A multi-table query with parent and child table fields with no criteria returns the ALL of the memo data. If any criteria is set for fields other than the memo field, the query returns the memo data truncated at 255 characters!!! Access 2002, searched knowledge base and found nothing specific to this issue. Other issues about 255ch truncation. Anyone know about this issue? Any fix?? Some other setting causing the truncation?? Thanks!!!! Joel . |
#4
|
|||
|
|||
Memo Field data truncated in query
If you ask Access to distinguish the records based on the value in memo
fields, it examines only the first 255 characters. If you understand what is actually involved in string comparisons that potentially involve tens of thousands of characters per record, you can appreciate that design choice. One work around with a Totals query is to use First instead of Group By under the memo field. This means that Access does not have to group by the memo field, and can just return the first matching memo field for the record, so it is free to return the entire memo field. Another workaround is to create a query that performs the DISTINCT operations you want without the memo field, and then use it as the input to another query that combines the first one and the table, retriving the value of the memo without doing further aggregation. HTH -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Joel" wrote in message ... Alan: Thanks, I have the unique values set to yes which creates the Distinct SQL clause. Is this true with all databases or just Access to limit Group By or Distinct Memo data to 255 characters? Thanks, Joel -----Original Message----- Several possible causes. The most common is that your query is performing some kind of aggregation which includes the memo field, e.g. if the query contains a GROUP BY clause that includes the memo field, or if there is a DISTINCT in the predicate. If that does not give you a useful lead, post the SQL statement from the query (by selecting SQL View from the view menu in query design). -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Joel" wrote in message ... TIA: I have a multi-table query; a child table has a memo field with lots of text. A multi-table query with parent and child table fields with no criteria returns the ALL of the memo data. If any criteria is set for fields other than the memo field, the query returns the memo data truncated at 255 characters!!! Access 2002, searched knowledge base and found nothing specific to this issue. Other issues about 255ch truncation. Anyone know about this issue? Any fix?? Some other setting causing the truncation?? Thanks!!!! Joel . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Memo export limited to 255 chars | Allen Browne | General Discussion | 8 | July 19th, 2004 07:57 PM |
Using a Union All and Transform on memo field crashes Access | Shane Holder | Running & Setting Up Queries | 5 | July 15th, 2004 02:30 PM |
Data Type field | Angel_G | New Users | 1 | July 13th, 2004 11:49 PM |
Append query - memo truncated to 765 characters | Martin Jeffreys | Running & Setting Up Queries | 3 | July 6th, 2004 02:57 PM |
Struggling with MS Query... | Alex | General Discussion | 5 | July 6th, 2004 11:46 AM |