[AccessD] bust out the math books

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




More information about the AccessD mailing list