It's bad idea to store numbers as a text.
You have to use query similar to:
UPDATE Transport SET c = CLng(a)-CLng(b)
As you can see, i use
CLng
function to convert text to long integer.
Note: Conversion may failed when text stored in that field cannot be explicitly converted.
For further information, please see:
CLng function[
^]
UPDATE statement[
^]