Query concatenates field

[Peter Kinross]

Here’s a weird one.
A query "qryRequirementsAction" concatenates a field [Requirements] to 255 chars. The field [Requirements] is from another query "qryRequirementsActionPre" where it is not concatenated. The field [Requirements] in the underlying table is a Memo field.
See query layouts below.

QueryLayout.jpg

How do I stop the field being concatenated?

[HansV]

Do you mean "truncates" instead of "concatenates"?

There are several situations in which Access truncates a memo field to a text field of 255 characters:
- If you apply any kind of format to the field.
- If you group the records in any way, i.e. if you have a Totals query (Σ is on) or if you have set the Unique Values property of the query to Yes.

[Peter Kinross]

Thanks Hans.
Yes I did mean 'truncate'.
The query "qryRequirementsAction" does have the Unique Values property set to 'Yes'.
Any ideas on how I might overcome this

[HansV]

Any ideas on how I might overcome this

By setting "Unique Values" to No, but that's probably not what you want.

Depending on the structure of the data, you might be able to get around this problem by removing the Requirements column from qryRequirementsAction, then creating a new query based on qryRequirementsAction and Policies, joined on Pol No, to add the Requirements field.