Extract part of a string

[JPR]

Hello,

I have a table with a filed named CustomerFileNo which is made of 10 digits plus one or two characters which identify the customer.
ex:
0000000000A
0000000000BB

I was trying to create a new field that only shows any digit or character after the 10th digit but can't get it working:

ex:
A
BB

I have created a textbox with the following code in the Control source:

Thank you for any help on this.

=RIGHT([C/N],,2)

 

[isladogs]

Remove one of the commas
=RIGHT([C/N],2)

Recommend you don't use special characters such as '/' in field or control names

 

[Mike Krailo]

=Mid([C/N], 11)

 

[Gasman]

=Mid([C/N], 11)

Yes, I was thinking Right could pick up the last digit if a single character like that A example.

 

[isladogs]

I agree Mid is the right answer. Forgot about the first example

 

[JPR]

Thank you