Must be a simple answer for 1 penny off

[dcavaiani]

I have related forms, Hdr and detail. The details total of extended and tax roll up and post to hdr fields named "totaloflines" (58.50) and "totaloftax" (2.93).

That should make a grant total of 61.43. However, on the hdr I have a field name sliptotal and the control source is (totaloflines+totaloftax), yet is shows 61.42 in that text field - which is 1 penny off?? All of these data fields and text fields are defined as currency with fixed and 2 decimal positions.

Yet, the sliptotal text field shows 61.424999 etc. when I hover over it.

 

[pbaldy]

You probably need to use the Round() function when calculating tax (or any calculated field).

 

[dcavaiani]

pbaldy, that was it. Had to go into the VBA and put rounding there! Thanks!

 

[pbaldy]

Happy to help!