I am not sure thils will do what i want. What i need i add an prefix to a number , so add a alpha character to a number.
in a query should that be something like:
Number | Newnumber: "A"+[Number] |
[TABLE] | |
I also tried Newnumber: CLng(Mid$("A", 2, Len("A"))) in the query but it's two times MyDataString, it doesn"t mention anywhere the original number so i guess it can't work.
You should tell the program => convert number to string and put an "A" in front of it and keep that value in Newnumber.
It shouldn't be that difficult but wxhat is the correct syntax ?