Copy last 2 digits of a cell

When I check marked is checked I would like it to save the last 2 digits from a field onto another field.

The field RawNumber will have the number in it. Such as 541248

When the check marked is checked, I'd like to the last two digits (in this case "48") to be stored in the field "Last2"

Thanks!
cansevinAsked:
Who is Participating?
 
GozrehConnect With a Mentor Commented:
Last2=Right([RawNumber],2)
0
 
cansevinAuthor Commented:
It works.. but only if the number is a small number. If it is more than 10 digits, it doesn't work. Any idea why? The field "rawnumber" isn't attached to a table field at all.
0
 
GozrehCommented:
It should work, maybe show your sample
Copy-last-2-digits-of-a-cell.accdb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.