Forum Discussion
KBreedlove50
Jan 16, 2022Copper Contributor
Right-to-Left sorting
Is it possible to sort the data in a column from right-to-left instead of the standard left-to-right? Use case: I want to sort addresses by the last characters in the street name to group all the "Rd...
- Jan 16, 2022Use StrReverse() function?
Make a field in your query StrReverse([fieldname]) and then sort on that column.
JurgenGeelen
Jan 16, 2022Brass Contributor
Use StrReverse() function?
Make a field in your query StrReverse([fieldname]) and then sort on that column.
Make a field in your query StrReverse([fieldname]) and then sort on that column.
- KBreedlove50Jan 17, 2022Copper ContributorThanks. It is just what I'm looking for and it works perfectly.
- KBreedlove50Jan 16, 2022Copper ContributorThanks, I'll try that.