How to get underlying rounded numbers in Access data cells?

L

Lenn Primm

I use Access to perform percentage calculations on currency values and then
store the product in a table data cell/record. Even though the record is set
for currency and to have just 2 decimal places ... the underlying value must
be showing additional decimal places. When I do sums in query or report, the
totals add up slightly different than what is visible in the data columns.
Any suggestions as to how the underlying data values to be a true 2 decimal
places?
 
O

Ofer

You can use the round function to get two decimal places

Round(MyNumber,2)

The 2 represent how many decimal places
 
Top