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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Canshrink question!! 2
Memo field does not grow - tried usual solutions 1
truncation of memo field supplied by DLookUp in a report 8
Report_Grouping 2
Repeating memo field 3
How do you allow memo fields to break for pages. 1
ODBC linked table -- Can't group by MEMO field 2
Memo field truncating in report 3

Back
Top