query a memo field

[davikokar]

Hallo,
I have this query based on a table with a memo field. In the query I have a count fuction and so I need the GROUP BY. The problem is that when I use the function an the GROUP BY the query will show only the first 255 characters of the memo field...
Do you know how to solve this?
thanks

 

[jrbarnett]

I've had similar things before, and this is a known limitation of Access memo fields.
My way around it was to take the memo field out of the query, and (in my case) to put it onto a report, I set the textbox controlsource to retreive the memo field with a DLookup statement, passing across the primary key of the table (which is also on the field) as the where clause argument to ensure the correct value was returned.

This is messy, it is far slower than retreiving it as part of the query, but its the best way I've found so far to get around the 255 character limitation.

John