Show Xth character in a string

[ECEK]

Easy peasy !!

I have a field that creates a number "noreq"
I have my field to search "searchfield"
I am looking to extract the "noreq"th character fron the "searchfield"

eg
noreq:7
searchfield:ABCDEFG
Result: G

Thanks

 

[plog]

Use the mid function:

https://www.techonthenet.com/access/functions/string/mid.php

 

[The_Doc_Man]

Darn, plog beat me to it while I was on another question.

 

[ECEK]

Thanks Guys

 

[jdraw]

You do check to ensure you have "noreq" or more characters, right?

Len(stringToSearch) >= noReq