PDA

Click to See Complete Forum and Search --> : Rounding Error Problem In Access


Tayewo
Feb 12th, 2006, 11:04 AM
I'm using Access 97 and I have been having problem with rounding error in my reports. I later found a solution to it with something like this: Sum(Int(Abs(variable)*100+0.5)/100). This worked perfectly untill the operating system (Windows XP)was reinstalled. Now the report does not come up. Instead I get an error message from Access asking whether to "Send Report" or "Don't Send Report"
Please, what do I do?
Thanks.

ganeshmoorthy
Feb 13th, 2006, 05:42 AM
have you tried the format function

Tayewo
Feb 13th, 2006, 06:56 AM
I've used Format but no satisfactory result.
What I don't understand is why it has been working since August 2005 only to fail in Febrary 2006.