[AccessD] A2K - Adding decimal error

Charlotte Foust cfoust at infostatsystems.com
Wed Apr 27 12:17:17 CDT 2005


I've seen it with addition as well.  You can build a test in code and
loop multiple times adding 1 to the integer of a floating point and
testing the mod to see if there is a remainder.  Believe me, it will
occur.

Charlotte Foust


-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk] 
Sent: Wednesday, April 27, 2005 9:37 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] A2K - Adding decimal error


Hi Reuben

Charlotte a guy? You better be careful!

You mostly see this with subtraction (which includes addition of
negative values); I've never seen it with addition of positives.

If you can't change the source data type be sure to wrap the values in
CCur(). If you need more than the four decimals of Currency you may
choose Double but round the results whenever possible.

/gustav

>>> reuben at gfconsultants.com 04/27 6:26 pm >>>
You guys nailed that one.  HoursWorked is a single.  I never considered
it would cause a problem with addition.  Of course, after all the work I
did on payroll calculations I can't beleive it was still a single.

Thanks.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Gustav Brock
Sent: Wednesday, April 27, 2005 10:53 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] A2K - Adding decimal error


Hi Reuben

He is probably adding and subtraction 0.1 hour as well and you are using
data type Single for that. Change to data type Currency ...

/gustav

>>> reuben at gfconsultants.com 04/27 5:38 pm >>>
A client came across this for me...

One employee has 10 pay records on one day that are each .6 hours. After
gathering all the pay info I use a standard grouping query with a sum to
get the total hours.

Rather than adding up to 6 hours, these 10 records resolve to
6.00000023841858

Why the strange decimals?

Thanks.

Reuben Cummings
GFC, LLC
phone: 812.523.1017
email: reuben at gfconsultants.com 

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



More information about the AccessD mailing list