Gustav Brock
Gustav at cactus.dk
Wed Apr 27 10:53:09 CDT 2005
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