I have a table containing a calculated field : [charge] *0.0169 problem with decimal places

[johnjenkin]

the field is set up as:

Expression: [charge]*0.0169
Result type: Currency
Format: Currency
Decimal places: 2
Text Align: General

The field in the table is displayed to 2 decimal places but when I click on the field it shows the result to 4 decimal places. I have this field on a report but when i use the sum command the total reflects 4 decimal places.

I want each calculation to be stored individually in the table as 2 decimal places, rounded.

[Minty]

The decimal places setting is only for display purposes, it doesn't change the data.

You will need to force the result of the initial expression to round to two decimal places.
That leads to a interesting question - What type of rounding do you want, as the inbuilt Access Round() function is about as much use as a chocolate teapot.

[Micron]

You might want to consider whether or not you should be storing calculations at all.
http://allenbrowne.com/casu-14.html

[johnjenkin]

Thank you for your reply. You mention 'i would need to force the result of the initial expression to two decimal places'. As I cannot change 0.0169 so can you let me know how i would do this?

[Minty]

I'm not sure how complicated you can get in a calculated field in a table.

You need something like

 Int((([charge]*0.0169)*100)+0.5)/100

This will force 2 decimal places with anything above .005 rounded up to the next value.