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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Subtract text after the third space and before the fourth (from between spaces) 3
Appending zero-length string 3
sort a text field by the length of it's string 3
Add character to end of string 3
Replace or insert characters in text string 6
Convert and sort date originally formated as text 3
Top n query using Allen Browne's "ConcatRelated" 3
extract 3 numbers from a string 0

Back
Top