Union query changes Memo to Text (256 char limit)

  • Thread starter Thread starter baldwin.kevin
  • Start date Start date
B

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.
 
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.
Click to expand...


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.
 
Back
Top