Can Access do multiple currencies

[Jackxxx]

I have a database app that has always been used for us currency, but know they need it to handle other currency, maybe CANADA. How can I do this?

Thank you,

 

[randy700]

What is the difference between Canadian currency and American currency?

Randy

 

[dhookom]

94.66%

Duane
Hook'D on Access
MS Access MVP

 

[Jackxxx]

Ok, Access has a money datatype, can this handle only US currency?

 

[dhookom]

I believe this depends on the Regional Options in the Windows Control Panel.

Duane
Hook'D on Access
MS Access MVP

 

[randy700]

AFAIK, the US and Canada both use dollars, 100 cents to the dollar.
What, exactly, do you want to do?


Randy

 

[Jackxxx]

So does this mean that no changes other than the regional setting in Windows would be needed to be made?

 

[dhookom]

Jackxxx,
I don't know since I never have to do this. Try it and let us know your results.

Duane
Hook'D on Access
MS Access MVP

 

[MajP]

I do not even get this question. As Randy points out of course it handles Canadian doallars. A dollar is a dollar. Both have the same symbol. The regional settings have no impact on currency both are dollars.

However, you develop in English UK and then open it in a English US setting, you may expect the pounds to become dollars. It may not. See discussion.

http://www.everythingaccess.com/tut...Currency-field-data-type---without-the-hassle

I hope no one thinks that Access connects to the internet, figures out todays exchange rate, and then converts the value. When you change regional settings the symbol just changes (or may not depending on above)
123.00 pounds
becomes simply
$123.00