Is there any way to reverse a string similar to this "2000 2001 2004 " so it looks like "2004 2001 2000".
I have tried StrReverse (strYears) without any success.
Some important things to note:
1) The number of years may vary in a string
2) There will always be an undetermined number of spaces at the end of the string
3) I'm using Access 2000
Any help would be appreciated.