I have a License Number Field that I want to Strip all of the characters off except the last three numbers. I am new to Access and I thought there might be a function or code to do this.

My License Number will be like this in each row which contains about 13,000 records: 031-000818501-000. In this example, I want only the last three numbers left which in this case would be 000.

Any quick way to do this? I believe there is.

Thanks

jjc9809


Joel Carmack

Right(fieldname,3)

If you'd like to first *check* that you have a dash followed by 3 digits, you could do that, too. But RIGHT (and LEFT and MID) functions and more are all available in Access SQL and in Access VBS coding.