Results 1 to 2 of 2
  1. #1
    wasim_sono is offline Advanced Beginner
    Windows XP Access 2013 64bit
    Join Date
    May 2005

    Calculation error

    Dear All

    I'm using some calculation in my form but the result varies a little as compare to physical calculation by calculator. Sample file is attached.

    The value of "per consumer capital cost" is 1672630 of feasibility no 9 but calculating by calculator it comes 1672636. similarly others feasibilities have difference in value.

    Please help to solve the problem.



  2. #2
    thhui is offline Competent Performer
    Windows XP Access 2002 (version 10.0)
    Join Date
    Feb 2009
    After I had scrutinized carefully your calculation in the access form, I found that
    your access file calculation is correct.

    You mistakenly format your total cost as integer.
    In fact, the true figure is not 73.6
    It is 73.59574.

    So the unit cost is 73.59574/44 = 1.67263
    The figure 1.67263*1000000 = 1627630
    That is exactly the value given by access of "per consumer capital cost"

    Usually, the common so-called error is in fact due to our carelessness of rounding and formating.

    The other cause for the error may be due to the precision level difference of your calculator (which brand?) and the access. In fact, the error is only marginal - after 6 decimal places.
    You amplify the difference by multiplying 1000000 on it.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Calculation Help
    By edge5511 in forum Programming
    Replies: 4
    Last Post: 12-18-2015, 11:11 AM
  2. I need to return a value for calculation.
    By FestoAccessBuilder in forum Access
    Replies: 1
    Last Post: 02-22-2009, 09:58 AM
  3. Date Calculation -- HELP!
    By klaauser in forum Forms
    Replies: 0
    Last Post: 12-22-2008, 02:14 PM
  4. Calculation is off by a few cents...
    By Jule in forum Reports
    Replies: 3
    Last Post: 05-01-2006, 01:06 PM
  5. Calculation
    By thestclair in forum Reports
    Replies: 1
    Last Post: 04-29-2006, 11:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums