Need to sort/group on Memo field

[Guest]

I have a situation where I need to sort/group on a memo field. Ita a memo
fielod because it may go over 255 characters but I'd be happy to sort on just
the first 255 chars. When I hit the down arrow in the sorting/grouping window
this field does not appear. How to get around this?

-David

 

[Rick Brandt]

I have a situation where I need to sort/group on a memo field. Ita a
memo fielod because it may go over 255 characters but I'd be happy to
sort on just the first 255 chars. When I hit the down arrow in the
sorting/grouping window this field does not appear. How to get around
this?

-David

You must be using Access 97. The newer versions would let you do the group
by and just automatically truncate at 255 characters. With 97 you have to
do it yourself. Instead of grouping on the field name, group on the
expression Left(FieldName, 255)

 

[Marshall Barton]

I have a situation where I need to sort/group on a memo field. Ita a memo
fielod because it may go over 255 characters but I'd be happy to sort on just
the first 255 chars. When I hit the down arrow in the sorting/grouping window
this field does not appear. How to get around this?

Try using an expression like =Left(memofield, 255) instead
of just the memofield's field name.