Charlotte Foust
cfoust at infostatsystems.com
Wed Apr 27 11:00:02 CDT 2005
I will wager that your hours are being captured in a double field. If so, change it to currency. What you're getting is floating point creep, which can occur even with simple addition/subtraction, and the only way to avoid it is to not use a floating point data type. Charlotte Foust -----Original Message----- From: Reuben Cummings [mailto:reuben at gfconsultants.com] Sent: Wednesday, April 27, 2005 8:38 AM To: AccessD Subject: [AccessD] A2K - Adding decimal error 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