Union query changes Memo to Text (256 char limit)

[baldwin.kevin]

Hi, I am using a Union query to join data from two different tables.
The columns that are joined include Memo data types. The recordset
after the union query truncates the Memo fields by quite a bit. I am
guessing that the fields' Memo data type have been changed to Text
data type. Is there any way to prevent this from happening? Thanks.

 

[Marshall Barton]

Hi, I am using a Union query to join data from two different tables.
The columns that are joined include Memo data types. The recordset
after the union query truncates the Memo fields by quite a bit. I am
guessing that the fields' Memo data type have been changed to Text
data type. Is there any way to prevent this from happening? Thanks.

That's to be expected because UNION performs an implicit
DISTINCT. And like DiISTINCT in a SELECT clause, the memo
fields are truncated to 255.

If you can, use UNION ALL instead.