Jim Lawrence
accessd at shaw.ca
Tue Jan 24 19:01:09 CST 2006
Hi Francisco: Are all the variables you are using and saving the values in are double/floating point variables? I have had issues when mixing various variable types like a Long and a Double involving any calculations. It can blow up within a conversion process. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Francisco Tapia Sent: January 24, 2006 4:50 PM To: Access Developers discussion and problem solving Subject: [AccessD] bust out the math books can someone answer me this: C1 C2 C3 1566 1770 0.884746 5130 5340 0.960674 1320 1800 0.733333 6440 7280 0.884615 1770 1800 0.983333 16226 17990 0.901946 If I take C1 / C2 I get C3... there must be a mathimaticall reason as to why I can't just average column C3 to get the 90%, instead I end up with 88.93% any thoughts? -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More... -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com