J jack555 Member Local time Today, 14:42 Joined Apr 20, 2020 Messages 93 Jul 26, 2022 #1 how to sort a field populated by expression? Created a filed TextLength using LEN([fieldname]; now need to sort the TextLength column by ascending or descending. However it is working. Please help.
how to sort a field populated by expression? Created a filed TextLength using LEN([fieldname]; now need to sort the TextLength column by ascending or descending. However it is working. Please help.
Minty AWF VIP Local time Today, 10:42 Joined Jul 26, 2013 Messages 10,725 Jul 26, 2022 #2 The simple way is to save that query, and then create another one based on it. Then you will be able to sort it, in the new query.
The simple way is to save that query, and then create another one based on it. Then you will be able to sort it, in the new query.
Ranman256 Well-known member Local time Today, 05:42 Joined Apr 9, 2015 Messages 4,352 Jul 26, 2022 #3 all expressions in a query have a name. you can name it in the query like: MySortFld: LEN([fieldname]
all expressions in a query have a name. you can name it in the query like: MySortFld: LEN([fieldname]
