Good day all.
I want to change the currency symbol! I only get the dollar sign $
I would like to change it ot the Euro Symbol € how do i get this done ?
Meaning I want Several the types to currency in database
Thanks in advance
Good day all.
I want to change the currency symbol! I only get the dollar sign $
I would like to change it ot the Euro Symbol € how do i get this done ?
Meaning I want Several the types to currency in database
Thanks in advance
Then you can't, access only allows 1 currency symbol.
To work around, you'd have to have a tCountry table, with each currency symbol..(I do).
then when you display the given curr field, format it without the symbol, format([fld],"0.00")
While appending the correct symbol from the tCountry table.
Thank you very much ranman256
I will try to work on it. But you want to get an example.
Thanks again
In your query, you would join it to the tCountry table. It has the CurrSym.
the result would be:
MyField: [tCountry].[CurrSym] & format([MonyAmt],"0,000.00")
Create a currency table, don't put it in country. Some countries use the currency of a "parent" region (Euro) or of another (Ecuador).
Then you can add the "primary" currency to the country table if you wish. Or, you can go nuts and create a table of all the currencies used in the country (Venezuela).
@twgonder
You may not have realized it, but the thread you posted to was over six years old. The OP is probably no longer following this link.
Alan
Thanks Alan, but someone else, new to the Forum like me, might stumble upon this thread.
If I think I have a solution worth posting and the thread is old, I try to remember to acknowledge its age when doing so. Then there's no need for anyone to point that out. The thread might show up in search engine results if it's a close match for the search and that would be good. However, like Alan I sometimes point out the age of a thread; especially if the late post contains things like questions.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.