MS ACCESS and REMOVING LAST TWO PADDED ZERO

Question

Hi folks,

I have several 1000's of values that have 2 padded zeros at the end of each value.

13-403170300

13-4031703

Is there any way I can use a code/formula in MS ACCESS to eliminate these last two padded Zeros?

Thank you!

Answer 1

off the top of my head:

update myTable set myField = left(myfield, len(myfield-2)) where right(myfield,2) = "00"

---

-Tom. Microsoft Access MVP

Answer 2

Thank you Tom. this should the trick. I BIGGER duplicate record problem. I'll open another ticket.