How do I get the 3rd 4th and 5th characters from a text field within a access dbase?
I have a table that i have numbers like;
I struggled through some vb code and got it to pull the 00 off the front of the numbers, but I also need to
generate a new number with the 3rd 4th and 5th character. This is the output i will need to get.
I feel luck to have made the vb work for the first part, and have spent all day trying to extract the middle number. Please teach me.
NOTE: the original data has some completely different data in it and it is all in text format.