hi, Can anyone help with this issue? I have a very simple sample access 2010 db with 3 records that should be producing the same amount in a calculated field on a report, but are not. I cant figure out why my rounding formula for the CALCULATED TOTAL on the Purchase Form is rounding perfectly for ALL combinations of numbers EXCEPT the numbers in a certain record. The problem is totally reproduce-able. I have also created a report so you can easily see the issue. The three records have the same TOTAL PRICE, but one of them is rounding up to $8 when it should be staying at $7. Something in the data is not as it seems.
The file is 800K which is more than the 500K max (ridiculously small!) allowed so I cant attach it but will be happy to email the sample file to anyone that would like to see if they can figure out this very weird problem!
Thanks much!
Jmark@stayintouch.us