part of a string in VB

[sham14]

I am trying to extract just a substring from a string in access. I want to do like the following:

fullstring = "john"
partstring = .....how do i get part of the string - for example read the last two digits to have partstring = "hn"

Thanks in Advance.

 

[CosmoKramer]

Try the Right function:

Right([fullstring],2)

 

[sham14]

Thanks Cosmo - worked great