Query truncating memo fields

[Hrithika]

I have a query that is truncating a memo field to 255 characters. There is no distinct, group by, format, union or concatenate in the query which are the common cause for truncation. Not sure what is happening. Please advise. Given below is the query. The truncated memo field is comments.

SELECT HearingAuditTbl.CASE_NUMBER, 
Null AS appealcaseid, 
HearingAuditTbl.HEARING_ALJ, 
Null AS DecisionCode, 
HearingAuditTbl.DECISION_DT AS ALJ_Date, 
HearingAuditViolations.VIOLATION_NO, 
HearingAuditViolations.COMMENTS, 
"CATEGORY_B" AS CATEGORY,
NOW() AS DATE_ADDED
FROM HearingAuditTbl 
LEFT JOIN HearingAuditViolations ON (HearingAuditTbl.CASE_NUMBER = HearingAuditViolations.CASE_NUMBER) AND (HearingAuditTbl.CASE_NUMBER = HearingAuditViolations.CASE_NUMBER)
WHERE (((HearingAuditTbl.DECISION_DT)>#6/30/2014#) AND ((HearingAuditViolations.VIOLATION_NO) In ('4','5','6','7','8','10A','10B','10C','11','12','14','16A','16B','16C','17A','17B','18','19','20','21','22','23A','23B','23C','24')) 
AND ((HearingAuditTbl.NONE)=0) 
AND ((HearingAuditTbl.AUDIT_TYPE)="MLC Audit") AND ((HearingAuditViolations.REMEDY)="NO") 
AND ((HearingAuditTbl.ACTIONCODE) Is Null) 
AND ((HearingAuditViolations.ACTIONCODE) Not In ('CS87','CS88','CS89','CS90'))) 
OR (((HearingAuditTbl.DECISION_DT)>#6/30/2014#) 
AND ((HearingAuditViolations.VIOLATION_NO) In ('4','5','6','7','8','10A','10B','10C','11','12','14','16A','16B','16C','17A','17B','18','19','20','21','22','23A','23B','23C','24')) 
AND ((HearingAuditTbl.NONE)=0) 
AND ((HearingAuditTbl.AUDIT_TYPE)="MLC Audit") 
AND ((HearingAuditViolations.REMEDY)="NO") 
AND ((HearingAuditTbl.ACTIONCODE) Is Null) 
AND ((HearingAuditViolations.ACTIONCODE) Is Null))

 

[pr2-eugin]

This is an existing problem ! http://allenbrowne.com/ser-63.html

 

[Hrithika]

I did read allenbrowne's article on truncation, but my problem is none of the factors he mentioned are in the query. Do you see something that I am missing?

Factors causing truncation
Aggregation
Uniqueness
Format property
UNION query
Concatenated fields
Row Source

 

[Hrithika]

The query is fine. It is fetching the results without truncation. I was doing something dump. I copied and pasted the results in excel. Here is the fix.

Do paste special and select csv..