I Am currently busy building a database using Microsoft Access 2007, one of the requirements are that each office in the database be able to use a different currency, so if the office is in the UK then the currency will be Pounds ect.
I have set up a table for all the different currencies, there symbols ect, and linked it to ease office.
But i just cant get Access to display princess according to the offices currency, using the correct currency symbol…
any help and suggestions will be much appreciated.