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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Dear Bruce:

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

Tom Ellison
 
Back
Top