• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 249
  • Last Modified:

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!
0
cansevin
Asked:
cansevin
  • 2
1 Solution
 
GozrehCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now