My database has a field called "CallNumber", and the data is formatted like this: N140040 It is limited to 7 characters with the first character as a Letter and the rest all numbers. When I created my database I had the field limited to 6 characters with the same format, example: N78345 . When I ran out of numbers I expanded the field to 7 characters still with the first character as a Letter etc., but now when I sort the old fields that have 6 characters go to the top of the list. They are older and should be at the botton of the list.
What I want to do is to is add a "0" between the Letter character and the the first number character. I tried using find and replace, but could not find a good method to add the "0" without changing the rest of the field characters.
This may be a simple task but right now I can't figure a good way to accomplish this task. Your help would simplify my task.
What I want to do is to is add a "0" between the Letter character and the the first number character. I tried using find and replace, but could not find a good method to add the "0" without changing the rest of the field characters.
This may be a simple task but right now I can't figure a good way to accomplish this task. Your help would simplify my task.