What function convert text value to numeric value

[a]

What function convert text value to numeric value

I want to sum 2 column in query

Cloumn1 column2

1 2

I'm use expr1=([column1]+[clumn2]) that give me 12

But I want the result = 3

 

[Maurice]

use: Val([fieldname])+Val([fieldname2])

that should work

hth