Search results

This is what I tried using the Replace function Replace([PropertyID],"3","",10,1)

Hi, yes the I always need to remove the 10th digit and it's always a 3, I don't have any of the code I tried yesterday as I deleted it when it didn't work. Whenever I tried using Left() it just returned everything after the 10th digit.

Hi, I found the Left,Instr,Mid functions when googling the problem but couldn't figure out how to get them to do what I wanted

Hi, I have a field called PropertyID which stores a unique 13 digit number, the 10th digit is always a 3. I want to remove the 3 to leave a 12 digit number. I've tried running an Update query using Replace([PropertyID],"3","",10,1) but no joy, what am I doing wrong? Thanks in advance