access currency and decimals

[crazytegger]

Hi all,

Im having trouble with currency formatting and the amount of decimals displayed. Most of my stored values are pretty standard ($10.50). Some item have a 4 decimal place cost though ($.0025). I have the table formatted to store 4 decimal places but when using the currency format it drops the last two places of the value. Is there a way around this or do i have to use general number format for the table? I also dont want the field to display 4 digits after the decimal if its not necessary. ($50.00 instead of $50.0000)

[PEB]

Hi,

As format of your digits you should choose General with 2 decimal places... But when there is .00 the .00 not be shown also!

There is functions to do truncation

For exemple you can use the follow:

Int(My_number*100+0.5)/100

So if your nember is 105.002
then 10500.2+0.5=10500.7
after int it gives 10500 then / 100 = 105.00 :)

[comteck]

There's something I'm not understanding here. Why do you have your table set up to display 4 decimal places, when you only want 2 for your currency?

comteck