MorningSun
Technical User
Many, Many, Many thanks to other posts in the forum that got me far enough to determine that this SQL WILL pull the entire memo field. Previously it was truncating at 255 characters:
SELECT tblSATEN.AuditNo, Avg(tblSATEN.Score) AS AvgOfScore, Count(tblSATEN.AuditNo) AS Transactions, "Enrollments" AS Item, First(tblSATEN.Policy) AS FirstOfPolicy, First(tblSATEN.SSN) AS FirstOfSSN, First(tblSATEN.Notes) AS FirstOfNotes, tblSATEN.Key
FROM tblSATEN
WHERE (((tblSATEN.Score) Is Not Null))
GROUP BY tblSATEN.AuditNo, tblSATEN.Key
HOWEVER, if I try to use this SQL in a UNION ALL query it truncates it again... so, the above works with no truncation but the below SQL results in a truncated memo field again:
SELECT tblSATEN.AuditNo, Avg(tblSATEN.Score) AS AvgOfScore, Count(tblSATEN.AuditNo) AS Transactions, "Enrollments" AS Item, First(tblSATEN.Policy) AS FirstOfPolicy, First(tblSATEN.SSN) AS FirstOfSSN, First(tblSATEN.Notes) AS FirstOfNotes, tblSATEN.Key
FROM tblSATEN
WHERE (((tblSATEN.Score) Is Not Null))
GROUP BY tblSATEN.AuditNo, tblSATEN.Key
UNION ALL SELECT tblSATEOI.AuditNo, avg(tblSATEOI.Score), Count(tblSATEOI.AuditNo) AS Transactions, "EOI" as Item,first(tblSATEOI.Policy),first(tblSATEOI.SSN),first(tblSATEOI.Notes),tblSATEOI.KEY
FROM tblSATEOI
Where tblSATEOI.Score is not null
GROUP BY tblSATEOI.AuditNo,tblSATEOI.Key;
Why is that? Oh, and the memo field is "Notes"
Any advice would be greatly appreciated!
PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.
SELECT tblSATEN.AuditNo, Avg(tblSATEN.Score) AS AvgOfScore, Count(tblSATEN.AuditNo) AS Transactions, "Enrollments" AS Item, First(tblSATEN.Policy) AS FirstOfPolicy, First(tblSATEN.SSN) AS FirstOfSSN, First(tblSATEN.Notes) AS FirstOfNotes, tblSATEN.Key
FROM tblSATEN
WHERE (((tblSATEN.Score) Is Not Null))
GROUP BY tblSATEN.AuditNo, tblSATEN.Key
HOWEVER, if I try to use this SQL in a UNION ALL query it truncates it again... so, the above works with no truncation but the below SQL results in a truncated memo field again:
SELECT tblSATEN.AuditNo, Avg(tblSATEN.Score) AS AvgOfScore, Count(tblSATEN.AuditNo) AS Transactions, "Enrollments" AS Item, First(tblSATEN.Policy) AS FirstOfPolicy, First(tblSATEN.SSN) AS FirstOfSSN, First(tblSATEN.Notes) AS FirstOfNotes, tblSATEN.Key
FROM tblSATEN
WHERE (((tblSATEN.Score) Is Not Null))
GROUP BY tblSATEN.AuditNo, tblSATEN.Key
UNION ALL SELECT tblSATEOI.AuditNo, avg(tblSATEOI.Score), Count(tblSATEOI.AuditNo) AS Transactions, "EOI" as Item,first(tblSATEOI.Policy),first(tblSATEOI.SSN),first(tblSATEOI.Notes),tblSATEOI.KEY
FROM tblSATEOI
Where tblSATEOI.Score is not null
GROUP BY tblSATEOI.AuditNo,tblSATEOI.Key;
Why is that? Oh, and the memo field is "Notes"
Any advice would be greatly appreciated!
PLEASE RECYCLE AND ENCOURAGE YOUR OFFICE/COWORKERS TO DO SO AS WELL.