ACC: Cannot Group by Memo or OLE Object Fields in Query (88926)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q88926 Novice: Requires knowledge of the user interface on single-user computers.
SUMMARY
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.
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kberrmsg kbinfo kbusage KB88926 |
---|
|