Rounding off Issue

  • Thread starter Thread starter Rica
  • Start date Start date
R

Rica

I'm having a rounding off issue which may have a simple
solution which I'm not able to figure out. There are 4
fields, A B C D. Field A is 4 decimal places, Field B is 2
decimal places, Field C is 2 decimal places and Field D is
again 2 decimal places. Field C is the product of ( B *
C ). Field D is Running Sum of Field C. The problem is
with the Running Sum that it adds up Field C with Field D
taking 4 decimal values and rounding off. Hence though it
shows only 2 decimal places but it is adding 4 decimal
places and rounding off, so it does not show exact total
of 2 decimal places. Any help would be appreciated. Thanks
 
Rica,

You will need to round the values on your report.

eg.

Round([c],2)

Will store only 2 decimal places (the 2 after the comma
defines 2 decimal places). For all calculations to appear
to be correct you may need to - Round([a],2)*Round(,2)
to ensure thew calculation is performed on only 2 decimal
places. Round the the whole lot to 2 decimal places if
required. Round(Round([a],2)*Round(,2),2)

HTH,

Terry
 
Back
Top