H Hendrix Sep 24, 2009 #1 I have a field with 9 numbers and I would like to extract the last 5. (ie 123456789 to 6789) Is that possible?
I have a field with 9 numbers and I would like to extract the last 5. (ie 123456789 to 6789) Is that possible?
K KARL DEWEY Sep 24, 2009 #2 Your example shows last 4, not 5. Try -- New_Field: Right([Old_Field], 5)
