Ok, so i've tried to search the forum for this issue, becuase i know leading zeros cause problems, but i hadn't found any answers that work for my situation.
I have code that is updating a table with ID numbers. I tried using an auto field but the update sql wouldn't work correctly, so this...