[AccessD] Multiple Currency types

John,

I do a lot of work for corporate finance of a large multinational firm and
what we do is save the amount along with the functional currency type. I
have a currency conversion table that gets updated from Oracle monthly;
the table includes the currency code, the USD conversion rate to foreign
currency rate and the foreign currency rate to USD.


Jim



> I have a field that is used to retain the historical cost of an item and
> up
> to now is has all been in US dollars. Just got one in UK pounds. There's
> more coming up too.
>
> I've never dealt with multiple currency types before. How do you suggest I
> store different currencies in my table? Do I need one column for amount
> and
> one for type of currency or is there a way to do this with formatting,
> masks, etc.
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>