MS Access 2003 write in SQL query to convert string to numeric
How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks
Software/Hardware used:
Software/Hardware used:
ASKED:
January 5, 2009 4:47 PM
UPDATED:
January 19, 2009 6:34 PM
RELATED QUESTIONS
Answer Wiki:
You can use expression builder to do same
CINT(TEXT value) will convert into numeric
I think you actually want CDbl(Text Value) if your dealing with non-integer values.
You can use VAL(Text value) to extract numeric value from string.
All Answer Wiki Contributors:
Michael Tidmarsh 
11,400 pts. ,
Dmargolis 35 pts. ,
Findsarfaraz 1,395 pts.
11,400 pts. ,
Dmargolis 35 pts. ,
Findsarfaraz 1,395 pts. To see all answers submitted to the Answer Wiki: View Answer History.
Cint(text1.text) – will covert the string(value) to an integer value.
val(text1.text)- will get the value from the textbox 1 and returns a value
Cdbl(text1.text) – will covert whatever is inside textbox 1 to and returns a value that supports decimal places in it.