Hello,
I've got a linked table from a SQL server where there is a column in Euro.
however the currency could be different depending on another field.
when showing this field in MS access it will always show the value in Euro.
now i need to change this field to show in USD format.
the field is showing as € 14.896,75
but i would like to show 14,896.75 $
can this be updated with a query in a temporary table?
what would be the best way to do this?
thanks,
Lucas