sorting by a memo field

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

Guest

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?
 
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)
 
Back
Top