Right-to-Left sorting

[KBreedlove50]

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" or "Road" together. Can this be done in Access and/or Excel?

[#2 · Accepted solution]

Use StrReverse() function?

Make a field in your query StrReverse([fieldname]) and then sort on that column.

[#3]

Thanks, I'll try that.

[#4]

Thanks. It is just what I'm looking for and it works perfectly.