Rounding Error Problem In Access
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.
Re: Rounding Error Problem In Access
have you tried the format function
Re: Rounding Error Problem In Access
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.