Currency on access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am setting up a database which will use different currencies, euro,
dolar and sterling. It seems I can display one type of currency ie euro only
or dollar only. Does anyone know how to get around this.

Thanks in advance,

Shane
 
Shane,

The way this is handled in the big ERP's world, is to use a numeric
field for the values and a text field right next to it to hold the
currency data in ISO (EUR, USD, GBP etc.); no €, $, (sterling symbol)
and such. This has the additional merit that the currency field can be
queried / bound to ROE tables etc. How about goibng that way?

HTH,
Nikos
 
Shane,

I didn't say it's the only way, I just proposed the one that I know. By
the way, in my experience, if ERP's do it that way it's good practice,
those systems are too big / expensive / critical to go wrong on the basics.

Nikos
 
Remember that what you store and what you display don't have to be the same
thing. For example ...

SELECT tblTest.Amount, tblTest.Currency,
Switch([Currency]="EUR","?",[Currency]="USD","$",[Currency]="GBP","£") &
Format$([Amount],"Standard") AS Expr1
FROM tblTest;

If there's any possibility that you may add additional currencies in the
future, you might want to consider adding a currencies table that would
include both the ISO code and the symbol. On the other hand, the larger the
number of currencies, the more attractive the idea of just using the ISO
codes and not using the symbols becomes.
 
Oops - I forgot to switch to an encoding that can display the Euro symbol -
hence the '?' in the previous post.

--
Brendan Reynolds (MVP)

Brendan Reynolds said:
Remember that what you store and what you display don't have to be the
same thing. For example ...

SELECT tblTest.Amount, tblTest.Currency,
Switch([Currency]="EUR","?",[Currency]="USD","$",[Currency]="GBP","£") &
Format$([Amount],"Standard") AS Expr1
FROM tblTest;

If there's any possibility that you may add additional currencies in the
future, you might want to consider adding a currencies table that would
include both the ISO code and the symbol. On the other hand, the larger
the number of currencies, the more attractive the idea of just using the
ISO codes and not using the symbols becomes.

--
Brendan Reynolds (MVP)

ShaneF said:
Thanks Nikos, Not happy with it, but if it is the only way.......Cheers,
Shane
Click to expand...
Click to expand...
 
Back
Top