I need to do the following update to a field depending on its contents I will put the logic that needs to be applied below.
If the first byte is NOT a 0 I need to add the 0 to the front of the string ex 2153 dg -> 02153 dg
after this i need to do the same thing on the third byte ex 02152 dg -> 020152 dg
the last thing i need to do is check the 9-10th bytes for characters, if no characters are present i need to input two letters
ex. 0201528 -> 0201528 XX
Im not sure if this can all be done in one update query or if i need to make 3 different ones. I'm not an expert with access, I wish I could just bypass a firewall and write a php script but this is not allowed.