Extract Letter From Field

[Roger Bolton]

Good day Access Gurus
Can you assist a newbie please?
I would like to extract the first letter of a field, then the second, then the third, etc. of that same field.
IE if the Field called [First Name] and my name is in that field = Roger

I need to Extract R
Then O
Then G

And not Rog
Thanking you in advance
Sincerely

Roger

[ADezii]

Dim strName As String
Dim intCtr As Integer
 
strName = "Roger"
 
For intCtr = 1 To Len(strName)
  Debug.Print Mid$(strName, intCtr, 1)
Next

OUTPUT:

R
o
g
e
r

[NeoPa]

A more helpful answer depends on where you're doing this Roger, but at the most basic level you need to use the Mid() function (whose full details can be found using Context-Sensitive Help).

Basically though :

Mid(String, Start, Length)

PS. ADezii gives a good illustration of how it might be used in VBA. Such flexibility is not available when used in SQL.