Memo field truncating :s

[k0r54]

Hi,

Ok, firstly i have search google and this forum from top to toe and no-1 has an answer that works for me.

I am running a query, now i have completely simplified it. The query is now just picking up a field called recommendations. Recommendations is a memo field with no formating or index on at all. Now, when i run the query as normal it works fine... everything is there. But when i have to group by it. It cuts it off at 255 charactors. The thing is i need to do some sums and counts within the query aswell so it has to be.

I have checked microsoft and there suggestions are not any use.

Any ideas???

 

[Brianwarnock]

From access help

You can sort or group on a Text field or a Memo field, but Access only uses the first 255 characters when you sort or group on a Memo field.

As Access is working as designed I guess you will have to workround the problem , maybe using more queries so that you do all the work then go back to pickup the memo field , I assume a memo field of over 255 characters isn't the way you select the grouping?

Brian

 

[k0r54]

such an annoying quirk, ok thanks for the tip i will have to try a work around