UNION query truncating MEMO field

[pattyjean]

I am trying to produce a report based on 3 queries and combined into one Union query for the report but my text cuts off at 255 after I add the second query.
Here is the SQL statement - any ideas?

SELECT comment1, sortmemo, selection, QNAME,Emplid,GROUP
FROM [qryBest-COMMENTS]

UNION ALL SELECT comment1, sortmemo, selection, QNAME,Emplid,Group
FROM [qrySECONDBEST-comments]

UNION ALL SELECT comment1, sortmemo, selection, QNAME,Emplid,Group
FROM [qryLEASTcomments];

 

[dhookom]

Have you checked the three queries to confirm the issue isn't with them?

Have you checked the datasheet view of the union query to confirm the truncation in the query or the report?

UNION ALL generally passes all characters from a memo field.

Duane
Hook'D on Access
MS Access MVP

 

[pattyjean]

Yes I did check all the tables and queries - I had a calculated field that I believe was the problem. I wanted to input Comment1=iif([comment]is null,"No comment Provided,[comment])
Once I deleted that statement it worked. I also had a count of group in the query and I took that out and added it to the report.

Thanks for your response