Data in Memo Field is truncated

[Guest]

I hope that someone can help me with this issue. It seems to be well
documented, but I have not found a solution.

I have a query in access the pulls data from two tables. Each is identical,
ID and Memo fields. If I run a query on each one individually the data in
the memo field is displayed correctly. If I run a Join Query against both
table, the data in the memo field is truncated to 255 characters.

Below is the SQL that is running.

SELECT Table1.ID1, Table1.data
FROM Table1
UNION
SELECT Table2.id, Table2.data
FROM Table2;

Any suggestions would be gratefully appreciated.

 

[Rick Brandt]

I hope that someone can help me with this issue. It seems to be well
documented, but I have not found a solution.

I have a query in access the pulls data from two tables. Each is
identical, ID and Memo fields. If I run a query on each one
individually the data in the memo field is displayed correctly. If I
run a Join Query against both table, the data in the memo field is
truncated to 255 characters.

Below is the SQL that is running.

SELECT Table1.ID1, Table1.data
FROM Table1
UNION
SELECT Table2.id, Table2.data
FROM Table2;

Any suggestions would be gratefully appreciated.

Since a UNION eliminates duplicates in the output it is forced to do a sort
across all the data fields and this causes truncation of memo fields. If
you use UNION ALL then this doesn't happen (but then you might get
duplicates).