Hello - I have a shared database with a query that pulls data from a table to create a report based on the selected user and date. There are 3 fields in the table that are Large Text - "AuditComments", "PositiveFeedback", & "Opportunity for Improvement". The query will truncate these fields but can't figure out the reason. Below is the sql for the query:
Code:
SELECT tblSalvageAudits.UserName, tblSalvageAudits.ClaimNumber, tblSalvageAudits.COL, tblSalvageAudits.[ISO & NMVTIS], tblSalvageAudits.StateCompliance, tblSalvageAudits.TitleWork, tblSalvageAudits.Proceeds, tblSalvageAudits.Activities, tblSalvageAudits.LogNotes, tblSalvageAudits.ProblemResolution, tblSalvageAudits.[Improve Recovery Opportunities], tblSalvageAudits.[Salvage Tab Entry], tblSalvageAudits.AuditComments, tblSalvageAudits.PositiveFeedback, tblSalvageAudits.[Opportunity for Improvement], tblSalvageAudits.OverallScore, tblSalvageAudits.AuditNameFROM tblSalvageAudits
WHERE (((tblSalvageAudits.UserName)=[Forms]![frmSalvageReports]![cboEmployeeQuarter]) AND ((tblSalvageAudits.OverallScore) Is Not Null) AND ((tblSalvageAudits.DateAudited) Between [Enter Start Date] And [Enter End Date]));
Thank you for any advice you can give me!
A little additional information -I have also checked the following:
Remove anything from the Format property of:
- the field in table design (lower pane);
- the field in query design (properties sheet);
- the text box on your form/report.