Train number field in the database set up here is that the text type, the text in this field I want to be removed following the first word, converted to digital form for addition, subtraction, multiplication, and division but for the wrong how can I change? Seek help from a great god

CodePudding user response:

Left (bala bala pile) changed to:
Mid (checi, 2)

CodePudding user response:

In fact, no arithmetic can also, you don't TDD is to distinguish has (odd)?

If InStr (" 13579 ", Right (checi, 1)) Then

CodePudding user response:

Checi=Right (checi, Len (checi) - 1) 'get checi get rid of the first character of string
X=Val (checi) 'transform checi into digital, can to calculated the variable x