sorting by a memo field

K

KimC

My memo field contains only 2 digits and I do not have the needed permission
to change its type. I need to sort a report on this field. Data sorts in
the query llike I want but not in the report. Is what I need to do possible?
 
M

Marshall Barton

KimC said:
My memo field contains only 2 digits and I do not have the needed permission
to change its type. I need to sort a report on this field. Data sorts in
the query llike I want but not in the report. Is what I need to do possible?
Click to expand...


Try sorting on the expression =Left(memofield, 250)
 
Top