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
|
|||
|
|||
Concatenation truncatation
I am creating a new field in a query that consists of a concatenation of
several strings and text fields. Occasionally the new field is greater than 255 characters and is truncated. Is there a way to designate this new field as a Memo field to avoid the truncation problem? If not, is there another way to avoid truncation? Thanks, David |
#2
|
|||
|
|||
Concatenation truncatation
The query should return all the characters unless you ask Access to
aggregate or de-duplicate on this field. Examples of things that will *not* work: a) Query has a DISTINCT predicate (must deduplicate all fields). b) This field is in the GROUP BY clause. (Use Expression on the concatenated field, instead of Group By.) c) UNION query. (Use UNION ALL instead). -- 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. "4110" wrote in message ... I am creating a new field in a query that consists of a concatenation of several strings and text fields. Occasionally the new field is greater than 255 characters and is truncated. Is there a way to designate this new field as a Memo field to avoid the truncation problem? If not, is there another way to avoid truncation? Thanks, David |
#3
|
|||
|
|||
Concatenation truncatation
Excellent! I changed from Group BY to Expression and it worked perfectly.
Thank you Allen Browne. David "Allen Browne" wrote: The query should return all the characters unless you ask Access to aggregate or de-duplicate on this field. Examples of things that will *not* work: a) Query has a DISTINCT predicate (must deduplicate all fields). b) This field is in the GROUP BY clause. (Use Expression on the concatenated field, instead of Group By.) c) UNION query. (Use UNION ALL instead). -- 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. "4110" wrote in message ... I am creating a new field in a query that consists of a concatenation of several strings and text fields. Occasionally the new field is greater than 255 characters and is truncated. Is there a way to designate this new field as a Memo field to avoid the truncation problem? If not, is there another way to avoid truncation? Thanks, David |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenation | Ken | General Discussion | 1 | April 12th, 2006 11:26 AM |
Duplicates In Concatenation | Wynn | Setting Up & Running Reports | 3 | January 31st, 2006 05:15 PM |
New Field is concatenation of other Fields | mcg2359 | General Discussion | 2 | March 24th, 2005 07:14 AM |
Concatenation for JulieD or any other Guru | JohnLute | Setting Up & Running Reports | 15 | October 7th, 2004 03:03 PM |
Concatenation giving #VALUE error? | denisecook | Worksheet Functions | 0 | May 4th, 2004 03:13 PM |