changing text "AU $9.95" to currency "9.95"

[Andrew Cheng]

Need to Change a text field of "AU $9,95" to a currency field "9.95" for
calculation. many thanks

 

[Wayne-I-M]

Hi

I'm not sure about AU currency types so you will / may need to alter the
right number but something like this should do the job - make a back up first
??

SELECT Val(Right([TableName]![FieldName],4)) AS NewCurrency
FROM TableName;