Reuben Cummings
reuben at gfconsultants.com
Wed Apr 27 11:26:18 CDT 2005
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