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.