How to get underlying rounded numbers in Access data cells?

L

Lenn Primm

For the purpose of providing payroll services to clients, 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 remain a true 2 decimal
places?
 
J

John Marshall, MVP

In the calculations apply a rounding or truncation formula like:

INT(CalcValue*100+0.5)/100

John... Visio MVP
 
Top