Can't group on memo

[jamphan]

I have a field on a table that is a memo 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?

 

[WayneRyan]

Jam,

The memo field is VERY specific to a particular row in your database.

If you include it in a Group By clause, how is Access (or Jet) to know
which memo field to include in the results.

Wayne

 

[The_Doc_Man]

Somewhere in the help files, you would find that Memo fields are not the same as many other fields. One of the problems is that you cannot make an index on a Memo field. Another is to not be able to make a Memo field a prime key. (Side effect of no index, actually.)

Look up Memo fields in your DB. Find out what you can and can't do.