Insert Character 1 character from right

  • Thread starter Thread starter P Brainard via AccessMonster.com
  • Start date Start date
P

P Brainard via AccessMonster.com

I want to insert a 0 character in every field of a column 1 character from the right side.

Not all the text strings are the same size.

original / need it to look like

55545 - 555405
632666 - 6326606
7777857 - 77778507
88888840 - 888888400
etc.


Help! Thanks.
 
Hi P,

This should be the trick.

Mid([TestStr],1,Len([TestStr])-1) & "0" & Mid([TestStr],Len([TestStr]))

Hope this will help.
 
John Spencer's response to your post yesterday addresses this.

Please refer to your previous post.

Rick B
 
Thanks JL. Perfect. Rick, the post from yesterday addressed strings of the same length. I had to adjust for differential in the length.
 
The one I sent you was for same length. The other post from yesterday did
address variabl length.


P Brainard via AccessMonster.com said:
Thanks JL. Perfect. Rick, the post from yesterday addressed strings of
Click to expand...
the same length. I had to adjust for differential in the length.
 
Back
Top