I have this function, which I use in an update query. It works well...:
I'm sure you have worked out it deletes the last three characters in a string.
I need to adjust it so that it only carries out the update IF the last three characters are text, not numeric. Should this criteria be added within the criteria box in design mode?
How do I amend the code, how does Access differenciate between text and numbers within a string.