[AccessD] Early Friday Untip

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().




More information about the AccessD mailing list