[AccessD] A2K - Adding decimal error

Reuben Cummings reuben at gfconsultants.com
Wed Apr 27 10:38:20 CDT 2005


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







More information about the AccessD mailing list