25 pts. 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 Question
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 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
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.
Browse more Questions and Answers on Development and Database.
Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.
