Need to sort/group on Memo field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
mscertified said:
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
Click to expand...

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)
 
mscertified said:
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?
Click to expand...


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