PUBLIC MARKS from ms_michel with tag access

Do not group by the Memo field. Instead choose First in the Total row under the memo field. This not only avoids the bug, and is much more efficient to execute, but it also allows JET to return the entire memo field instead of truncating it at 255 characters.

Microsoft Access ne peut pas regrouper en un champ Mémo ou un champ objet OLE dans une requête. En outre, la clause GROUP BY d'une instruction SQL ne peut pas inclure champs Mémo ou Objet OLE.