G
Guest
not allowing a international company to choose the currency for the data base
renders access unusable for most applications
renders access unusable for most applications
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Graham R Seach
Gee, and all this time I thought currency was determined by your Regional
settings!
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
settings!
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
E
Ed Warren
The currency type is set in the regional settings ($,£ ,¥, etc). However,
access really does not understand 'currency' it just stores it as a floating
point number (xx.yy....). So if you need for people in different locales to
share currency data you will have to either decide on a 'coin of the realm"
everyone uses or build a data structure that stores at least a number
(15.00) and a currency type (dollar, pound, euro, yen) in the database then
a currency conversion routine to present it to the local user.
Ed Warren
access really does not understand 'currency' it just stores it as a floating
point number (xx.yy....). So if you need for people in different locales to
share currency data you will have to either decide on a 'coin of the realm"
everyone uses or build a data structure that stores at least a number
(15.00) and a currency type (dollar, pound, euro, yen) in the database then
a currency conversion routine to present it to the local user.
Ed Warren
R
Rick Brandt
Graham said:Gee, and all this time I thought currency was determined by your
Regional settings!
Regards,
Graham R Seach
Microsoft Access MVP
That can't be right. If I create a database with a date field and a currency
field and enter January 15, 2005 and 150 dollars respectively and my regional
settings cause them to be displayed as...
1-15-2005 $150.00
....and I send that database to a user in the UK his regional settings will
likely cause the date to be displayed differently...
15-1-2005
While it looks different, this is still the same date. His regional settings
should NOT cause the currency value to display as 150 pounds because that is not
the same value as 150 dollars.
I was under the impression that once set in the database that the currency
format is "fixed" to avoid just this issue. Is that not the case?
E
Ed Warren
Can't say anything about sending $ to the UK but when my clients in the UK
enter £10, and they ship the databases to me in the U.S. I see $10.00. I
strongly suspect it works the same the other way around. I have to control
the presentation by forcing the use of £ in the format string
£###,###.##
Ed Warren
enter £10, and they ship the databases to me in the U.S. I see $10.00. I
strongly suspect it works the same the other way around. I have to control
the presentation by forcing the use of £ in the format string
£###,###.##
Ed Warren
G
Graham R Seach
The OP's original issue was complaining about not being able to *choose* the
currency. I took that to mean *at each locale*.
There's no point complaining that Access can't convert currency from one
format to another, because no other database will do that either.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------
currency. I took that to mean *at each locale*.
There's no point complaining that Access can't convert currency from one
format to another, because no other database will do that either.
Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------