Finding the last space in a string

[houseofturner]

I need to strip out everything before the last space in a string. I can use the Instr function to find the position of the first space but cant work out how to use it to find the position of the last space?

So if I have the text "This is what I want" the query should return "want"

Any ideas???

 

[boblarson]

Here's a function that would return it.

Function RetLast(strInput As String) As String
   RetLast = Right(strInput, Len(strInput) - InStrRev(strInput, " "))
End Function

 

[houseofturner]

Great thanks.