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

From: Shamil Salakhetdinov <shamil@marta.darts.spb.ru>
To: <accessd@mtgroup.com>
Subject: Re: [accessd] Sorting on a memo field
Date: 31 May 1999 13:52

Rocky,

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

HTH,
Shamil