Query not picking up all the memo detail - Help Please

[101287]

Have the following query but the LastOfLastOfSDNote_Note is not picking up all the information. Would like to be able to retrieve all the detail information that is in that memo field.

Suggestion will be greatly appreciated.


SELECT qrySubNotes.SDNote_Supplier_ID, Last(qrySubNotes.SDNote_Date) AS LastOfSDNote_Date1, Last(qrySubNotes.LastOfSDNote_Date) AS LastOfLastOfSDNote_Date, Last(qrySubNotes.LastOfSDNote_Note) AS LastOfLastOfSDNote_Note
FROM qrySubNotes
GROUP BY qrySubNotes.SDNote_Supplier_ID;

 

[Remou]

Memos are often truncated in queries. Here are some notes:

http://allenbrowne.com/ser-63.html