>Doesn't Val() work?
No val stops at the ","
>
>Alan
>
>>Hi all,
>>
>>Does anyone know of a quick and easy (to be used in a select statement) way to convert a transformed amount back to its value.
>>
>>If I originally had the number 12345.67
>>this has become the string "12,345.67" or "12.345,67" depending on the separators.
>>
>>and now I need to do a numeric > or < so I need it as a number again.
>>
>>Any ideas?
>>PS I can't store it as both so that is not an option.
Caroline