Sorting on a memo field

Question

I have had a request from a user to be able to sort a report on a memo field (a part description - to make a parts catalog). It's a reasonable request, the app should allow this feature. So I'm going to do it. Question is: what's the best way? The sort will be effective if it's done on the first 30 characters of the field.

Answer

Rocky,

I think you can use Mid(<YourMemoField>,1,30) as SortField in report's query...

HTH,
Shamil