UNION query results in memo column being truncated

[Guest]

The following union query results in a memo column returned by
qryPkgRuleIssues being truncated. The query when executed standalone returns
the full text of the column. How do I avoid this problem?

SELECT * FROM qryRptPkgIssues
UNION SELECT * From qryPkgRuleIssues
ORDER BY Closed, Created;

 

[John W. Vinson]

The following union query results in a memo column returned by
qryPkgRuleIssues being truncated. The query when executed standalone returns
the full text of the column. How do I avoid this problem?

SELECT * FROM qryRptPkgIssues
UNION SELECT * From qryPkgRuleIssues
ORDER BY Closed, Created;

Use UNION ALL instead of UNION. The UNION operator by itself removes
duplicates, and in order to detect duplicate values in Memo fields Access
truncates them.

John W. Vinson [MVP]

 

[Marshall Barton]

The following union query results in a memo column returned by
qryPkgRuleIssues being truncated. The query when executed standalone returns
the full text of the column. How do I avoid this problem?

SELECT * FROM qryRptPkgIssues
UNION SELECT * From qryPkgRuleIssues
ORDER BY Closed, Created;

Can you use UNION ALL instead of UNION?