Memo field, will show only partial contents on Query

[Joe8915]

Running 2007

I never ran into this problem before.
I have a qry, with showing totals (group by). One of the fields is called comments, which is a memo field. I am only seeing partial comments.

When I redesign the query and take out the "totals", I see the entire comments.

Is there a fix to this?

 

[Treason]

Memo fields are truncated to 255 characters if you use group by.
There is no workaround other than modifying your query.

 

[gemma-the-husky]

you wont be able to group by memo comments anyway. group by brings "like" items together and it is very unlikely that memo items will be identical - you cant actually sort memo items - but it is possible that the group by takes the first 255 chars of a memo, and sorts/groups based on those - have another think about it

 

[Joe8915]

Thanks for the quick reply, I think I fix it. I just created new qry and link the one qry I was having trouble with and just added the table with the memo field and it seems to work.

 

[gemma-the-husky]

the trouble is, when you group by, you will have one instance of each group

if you now link back to pick up the memo field, it may be OK, but you may only be getting one random instance of each record, rather than all the records