UNION query results in memo column being truncated

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

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]
 
mscertified said:
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;
Click to expand...


Can you use UNION ALL instead of UNION?
 
Back
Top