none
MS ACCESS and REMOVING LAST TWO PADDED ZERO RRS feed

  • 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!

    Thursday, October 10, 2019 5:23 PM

All replies

  • off the top of my head:

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


    -Tom. Microsoft Access MVP

    Thursday, October 10, 2019 6:04 PM
  • Thank you Tom. this should the trick. I BIGGER duplicate record problem. I'll open another ticket.  
    Thursday, October 10, 2019 7:19 PM