sql - Access Update Query First 5 digits, but last number goes up one -

i using access update query change column first 5 digits, got part. need last digit go one. if 12345 need 12346.

this have far:

left([num],5) 

try this:

clng(left([num], 5)) + 1 

the clng necessary if original column isn't number field.