Gustav Brock
gustav at cactus.dk
Tue May 4 13:46:28 CDT 2004
Hi Charlotte > I know that. I know. > Did I misunderstand your question? You wrote: " .. They seem to be under the impressions that you're safe if you stick to adding or subtracting." > No mathematical operation is safe from floating point creep that I > know of. I think that's the way to put it. /gustav > Ahh, but also subtraction (which includes addition of mixed positives > and negatives) certainly isn't safe. Try: > ? 10.1 - 10.0 > Should return 0.1 ... > You must use CCur() or CDec() for this. > /gustav >> No, I was implying that many people think they're safe as long as they >> don't use multiplication or division. Not true. >> Charlotte Foust >> -----Original Message----- >> From: Gustav Brock [mailto:gustav at cactus.dk] >> Sent: Tuesday, May 04, 2004 7:48 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] Early Friday Untip >> Hi Charlotte >> Oh, my comments were not meant to be inclusive .. >> And you mean "adding and not subtracting", right? >> /gustav >>> Well Val() is officially included for backward compatibility (I guess >>> they never mentioned that to the VB team <g>), and a lot of people >>> simply don't understand the issues of floating point errors. They >>> seem to be under the impressions that you're safe if you stick to >>> adding or subtracting. If you want to add another omission, CCur().