Calculation - formation of digits

[stephenchan433]

Hi Everyone,



hoping someone can help me out with this formatting issue. Is there a way that I can maintain ALL the decimal digits while just displaying only 2 decimal points? I have an excel spreadsheet and it's easy to do that and the numbers that I have compared to Access is always a couple of cents off do to Access rounding the decimal points.

thanks

[June7]

Access can retain 13 decimal digits.

In Excel I can set formatting for 30 digits but it shows what I entered only for 14. All the digits after 14th show 0 no matter what I enter.

I find it odd that rounding to 2 decimals shows any difference. Exactly where and how are you doing the formatting?

[vicsaccess]

that depends on where you are trying to do it and then display. if you are doing your calculations in a query, easy. click on the field with the expression and bring up properties, then use the format, select standard. it will display only two but keep all your decimals for other expressions. if in a form, will have to use the format function.

[June7]

Well... textbox on form has Format property. All the digits are there but only 2 display - until you click into the box then they all show so can be edited.