Query part of a text field

[Raaff]

I need to query a text field where the last 1 or 6 positions of the field always consists of a number. I want to be able to query that number. Now normally I would expect a seperate field in the table for that number. Alas, the manufacturer of the program has decided to store it in this way:

"some odd text <space>123456"

Now I am building a custum report not available in the program. Any ideas as to how I could query the number?

 

[John Big Booty]

You should be able to do it with something along the lines of;

[URL="http://www.techonthenet.com/access/functions/string/right.php"]Right[/URL]("YourTextHere", [URL="http://www.techonthenet.com/access/functions/string/len.php"]Len[/URL]("YourTextHere" - [URL="http://www.techonthenet.com/access/functions/string/instrrev.php"]InStrRev[/URL]("YourTextHere", " ")))

 

[vbaInet]

Or:

mid("YourTextHere", instrrev("YourTextHere", " ") + 1)