[AccessD] Early Friday Untip

I know that.  Did I misunderstand your question?  No mathematical
operation is safe from floating point creep that I know of.

Charlotte Foust

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Tuesday, May 04, 2004 9:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Early Friday Untip


Hi Charlotte

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

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com