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.
I think you can use Mid(<YourMemoField>,1,30) as SortField in report's query...
Copyright © 1999-2008 by Shamil Salakhetdinov. All rights reserved.