<div>
dim sList$()<br />
dim iCounter%<br />
dim sDone$<br />
sList = Split(sInput, &quot;&nbsp;&quot;)<br />
for iCounter = ubound(sList) to lbound(sList) step -1<br />
&nbsp; sDone = sDone &amp;&nbsp;&quot; &quot;&nbsp;&amp; sList(iCounter)<br />
next<br />
sDone = Trim(sDone)<br />
<br />
Done :)
</div>


dim sList$()
dim iCounter%
dim sDone$
sList = Split(sInput, " ")
for iCounter = ubound(sList) to lbound(sList) step -1
  sDone = sDone & " " & sList(iCounter)
next
sDone = Trim(sDone)

Done :)

<div>
Use this new function StrReverse(). 
</div>


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

</div>
</div>



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.



reverse a string

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.