Can't group on memo error

[Todd]

I have a field on a table that is a memo format field. I am trying to write a
query to include this field but get the "Can't group on memo or OLE object.
Any ideas on why and how can I query with this memo field included?

 

[Jeff Boyce]

Todd

From the error message you reported, I'll guess that the query you are
trying to write is a "Totals" query.

Given all the potential for variety, mispelling, mis-punctuating, etc. that
can happen in a memo field, I also suspect you do NOT want to try to
"GroupBy" this field (even if Access would allow you to).

If you want to display a record's memo field, you won't be able to use a
Totals (GroupBy) operation. After all, if you group by one field in your
table, which of the rows' memo field would be the correct one to associate
with the group?

Can you describe a bit more what outcome you hope for, rather than what
approach you've taken? It would help to get an idea of how your data is
structured, too.

Regards

Jeff Boyce
<Office/Access MVP>