Results 1 to 2 of 2
  1. 10-27-2008, 09:57 AM #1
    alokshri67
    alokshri67 is offline Novice
    Join Date
    Oct 2008
    Posts
    1

    Difference of two same value is coming in Scientific notetion.

    I am finding a difference of two double value which are same but instead of zero it returns Scientific notation.
    i.e.



    1,484.14 - 1,484.14 = 2.27373675443232E-13

    Why?.


    Alok.
    Reply With Quote Reply With Quote
  2. 11-08-2008, 10:40 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Because floating point is just an approximation. Try using Currency data type and see what happens.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Time difference
    By jguidry in forum Programming
    Replies: 1
    Last Post: 11-15-2008, 12:41 PM
  2. calculate difference of $$ than can display in the subtotals in a report
    By taniuca in forum Queries
    Replies: 0
    Last Post: 08-07-2008, 07:02 PM
  3. show difference of amounts in a report
    By taniuca in forum Reports
    Replies: 0
    Last Post: 08-07-2008, 06:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums