How do I sort (query) by text string length in Access?

A

Allen Browne

To sort a query on the number of characters in Field1, enter this into the
Field row of your query:
Len([Field1])
and choose Ascending (or Descending) in the Sorting row under this.
 
T

Tom Ellison

Dear Bruce:

Create a column calculating Strlen(YourColumnName). Don't display it, but
sort by it.

Tom Ellison
 
Top