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

Need to Change a text field of "AU $9,95" to a currency field "9.95" for 
calculation. many thanks
0
Utf
1/21/2008 12:46:02 PM
access 16762 articles. 3 followers. Follow

1 Replies
1251 Views

Similar Articles

[PageSpeed] 51

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;



-- 
Wayne
Manchester, England.



"Andrew Cheng" wrote:

> Need to Change a text field of "AU $9,95" to a currency field "9.95" for 
> calculation. many thanks
0
Utf
1/21/2008 1:37:02 PM
Reply:

Similar Artilces:

changing text "AU $9.95" to currency "9.95"
Need to Change a text field of "AU $9,95" to a currency field "9.95" for calculation. many thanks 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; -- Wayne Manchester, England. "Andrew Cheng" wrote: > Need to Change a text field of "AU $9,95" to a currency field "9.95" for > calculation. many thanks ...