Link to home
Start Free TrialLog in
Avatar of cansevin
cansevin

asked on

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!
ASKER CERTIFIED SOLUTION
Avatar of Gozreh
Gozreh
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cansevin
cansevin

ASKER

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.
It should work, maybe show your sample
Copy-last-2-digits-of-a-cell.accdb