A Allen Browne Nov 21, 2005 #2 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.
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 Nov 21, 2005 #3 Dear Bruce: Create a column calculating Strlen(YourColumnName). Don't display it, but sort by it. Tom Ellison
Dear Bruce: Create a column calculating Strlen(YourColumnName). Don't display it, but sort by it. Tom Ellison
M Marshall Barton Nov 21, 2005 #4 All strings are text only. Click to expand... Add a calculated field: TextLen: Len(textfield) and sort on that.
All strings are text only. Click to expand... Add a calculated field: TextLen: Len(textfield) and sort on that.
M Marshall Barton Nov 21, 2005 #5 All strings are text only. Click to expand... Add a calculated field: Text