Reuben Cummings
accessd at gfconsultants.com
Wed Dec 9 12:39:40 CST 2009
Can anyone explain to me, given the following two sets of numbers why I get the answers I do in Access? I'll also provide the answers to the same numbers and equations in Excel. Access simply seems to be rounding wrong. And these are only 2 out of 22. The other 20 are correct. ============================================= .47 206104.58 118507.98 3312.20 16 4274.27 Total = 332215.50 % = .258099 If I do Round(Total*%,2) I get 85,744.48 In excel I get 85,744.49 The number, before rounding is 85744.48833 ============================================= The 2nd set is 66986.81 29694.41 1837.46 Total = 98518.68 % = .253696 Round(Total*%,2) in Access gives me 24,993.79 Excel gives me 24,993.80 Before rounding it is 24993.79504 ============================================= Why the rounding errors? Reuben Cummings GFC, LLC 812.523.1017