Group by truncating field

[Question Boy]

I have a simple query

SELECT [Tbl Contacts].First, [Tbl Contacts].Last, [Tbl Contacts].Notes
FROM [Tbl Contacts]
GROUP BY [Tbl Contacts].First, [Tbl Contacts].Last, [Tbl Contacts].Notes;

However, it is truncating the content of my memo field Notes. How can I
return the complete field value?

Thanks,

QB

 

[Allen Browne]

In the Total row under your memo field in query design, use First instead of
Group By.

Explanation:
Truncation of Memo fields
at:
http://allenbrowne.com/ser-63.html