I have been looking in to the problem that I have been having, and the main issue is that Access does just that, it reports the currency format according to the PC's location and settings. we have our head office in Australia and each month we have to send our other offices Statements to show them how much money they have to transfer to us, each statement for each office that we make in the head office should be in the offices local currency.
For example:
London Office = Statement in Pounds
Montana office = Statement in USD
I do relies that I will have to build exchange rates in to this database as well in order to get sales reports act reporting sales correctly.
Some back ground:
My statement report is based on a Query that gets the office info, Statement charges, bank account details and currency for each office. In order to be able to open or create a statement you have to enter a date range for the statement.
So here is what I have come up with so far to help solve this issue:
1. Change all fields that were currency fields to Number.
2. Added Exchange rates table to the database.
3. On the report add some VB code to check what office the statement is for and then apply a custom formatting to the currency fields on the report.
The only thing is that I am very rusty on my VB code...