Originally Posted by accessman2
how to convert String to Currency, and also, Currency is Standard form (eg 2334.00, NO dollar sign$)
Please let me know, thanks.
Hi. I dont know exactly what you wish to do hoping this will help...
Lets say your in the queries view and theres a column you want to convert into numeric but there might be some ALPHABET value which you cannot convert it....
Assuming table name is TEST and Field Name is FIELD1
SELECT IIF(IsNumeric(FIELD1),VAL(FIELD1),0) AS Output FROM TEST
You can use the combination of IIF function and IsNumeric