Home > IT Answers > Development > MS Access 2003 write in SQL query to convert ...
SacramentoSil
25 pts.
0
Q:
MS Access 2003 write in SQL query to convert string to numeric
SQL, Microsoft Access, Access 2003, SQL Query
How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks
ASKED: Jan 5 2009  4:47 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Msi77
790 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
You can use expression builder to do same
CINT(TEXT value) will convert into numeric

http://findsarfaraz.blogspot.com

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.
Last Answered: Jan 19 2009  6:34 PM GMT by Msi77   790 pts.
Latest Contributors: Dmargolis   35 pts., Findsarfaraz   1395 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0