Article ID: 88926 - View products that this article applies to.
This article was previously published under Q88926
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
If you attempt to create a select, update, or append query that groups by a Memo field or OLE Object field, you may receive the following error message:
Can't group on Memo or OLE object (<fieldname>).
Microsoft Access cannot group by a Memo field or OLE Object field in a query. Also, the GROUP BY clause of a SQL statement cannot include Memo or OLE Object fields.
To include a Memo or OLE object field in a totals query, drag the field to the QBE grid and select the aggregate (totals) function First() or Last() in the Total row for that field.
You can group by the first <n> characters in a Memo field by using an expression. To group by the first 25 characters in a Memo field called Description, follow these steps:
Article ID: 88926 - Last Review: October 26, 2013 - Revision: 3.0