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

 

Copyright 1999-2008 by Shamil Salakhetdinov.  All rights reserved.