Need to Change a text field of "AU $9,95" to a currency field "9.95" for calculation. many thanks
A Andrew Cheng Jan 21, 2008 #1 Need to Change a text field of "AU $9,95" to a currency field "9.95" for calculation. many thanks
W Wayne-I-M Jan 21, 2008 #2 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;
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;
