Change currency in table

[ant1983]

Very cimple one probably...

when i create a table and set one of my fields to a currency it shoulds
Pounds Sterling...

How do i change that to another format? I wana use "QR" instead...

Ta...

 

[Wayne-I-M]

Hi

You can't - well OK you "could" but this would need to be done in the
regional settings on the control panel. As (I think) access will also take a
few (dollar, Euro, ect) standard currencies.

Best bet would be not to use a currency (Qatari Riyal ) format. Use a
number (set the decimal places to watever you want) and then concencate this
in a report/form/query with the QR pre-script.

HTH

 

[John W. Vinson]

Hi

You can't - well OK you "could" but this would need to be done in the
regional settings on the control panel. As (I think) access will also take a
few (dollar, Euro, ect) standard currencies.

Best bet would be not to use a currency (Qatari Riyal ) format. Use a
number (set the decimal places to watever you want) and then concencate this
in a report/form/query with the QR pre-script.

I'd have to disagree here: Single and Double number datatypes will risk
problems with roundoff error. A Currency datatype (as a scaled huge integer
with exactly four decimals and no roundoff truncation) may well be a better
choice. You can use the Format property to display QR or any other needed
currency designation.

 

[Wayne-I-M]

hmmmm. Not really sure about that - as the "numbers" being entered would
never be split to less than .01 (ie 12.34 456.67 etc) the round problem
would not occure as the "currency" would not be divided or multiplied - ie
you would not have $12.34 X $56.78 but you may have $12.34 + $56.78

So the rounding would not happen

But John I have never seen an answer that you have given that is not right
so I will accept it as always

 

[John W. Vinson]

hmmmm. Not really sure about that - as the "numbers" being entered would
never be split to less than .01 (ie 12.34 456.67 etc) the round problem
would not occure as the "currency" would not be divided or multiplied - ie
you would not have $12.34 X $56.78 but you may have $12.34 + $56.78

So the rounding would not happen

But John I have never seen an answer that you have given that is not right
so I will accept it as always

Actually I'm wrong and you're right here - Currency fields DO have four
decimals (no more, no fewer), so some division and multiplication could
generate concealed fractional cents. You just need to be aware of this and the
possible solutions.