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;