Concatenation truncatation

[Guest]

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

 

[Allen Browne]

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).

 

[Guest]

Excellent! I changed from Group BY to Expression and it worked perfectly.
Thank you Allen Browne.

David