View Single Post
Old 07-11-2019, 04:06 AM   #1
Newly Registered User
Join Date: Dec 2016
Posts: 95
Thanks: 47
Thanked 1 Time in 1 Post
Cark is on a distinguished road
Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Setting

I am trying to create a Table with a field which is in US Dollars.

I am building the database on a computer which is set up with GBP Pounds as the default currency in Regional Settings. The database will always be used by computers using GBP Pounds as the default currency (all UK based), however the prices in this particular column need to be stored as Dollars as this is what the majority of costs will be calculated using.

I have done a bit of looking around on google, but could not find how to get around Access changing the currency to whatever is in the regional settings.

Any ideas?

Cark is offline   Reply With Quote