[AccessD] More in Queries and Memo Fields

>From Allen Browne’s site: (http://allenbrowne.com/QueryPerfIssue.html)

-------------------
This makes a major difference with Memo fields. If you GROUP BY a memo
(Notes in the example), Access compares only the first 255 characters, and
the rest are truncated! By choosing First instead of Group By, JET is free
to return the entire memo field from the first match. So not only is it more
efficient; it actually solves the the problem of memo fields being chopped
off.

(A downside of using First is that the fields are aliased,
e.g. FirstOfNotes.)
-------------------

Dan