What function convert text value to numeric value

A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Converting a numeric field to text 1
VBAscript for data matching excels 0
Convert string value to numeric value 3
Query expression builder returns text instead of numeric 3
Use Combobox column in Query 4
Convert Text to number 8
Update query shift down by 1 0
Numeric Field Overflow when appending date - how to convert it to text 1

Top