Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    HIGHLY RECOMMENDED READING Access Rounding & Math (Any)

    Due to some recent messages on the subject, I highly recommend anyone using Access read the following information about possible problems with their math. Read it carefully, it's not just VBA that's being talked about. Queries can also have math problems as mentioned in the Technical Paper.

    <A target="_blank" HREF=http://www.fmsinc.com/tpapers/math/index.html>http://www.fmsinc.com/tpapers/math/index.html</A>

    I don't have Access XP to check it all out with, but the math problems crop up in my 97 and 2000 testing.

    This posting is not meant to scare anyone, however, you really need to take a serious look at what you do in code and/or formulas in any application.

    FWIW
    TomG

  2. #2
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: HIGHLY RECOMMENDED READING Access Rounding & Math (Any)

    OK, OK, so it's an IEEE Floating Point issue not just a VB/VBA issue.

    This is helpful to read also: <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q42/9/80.ASP>http://support.microsoft.com/support/kb/ar...es/Q42/9/80.ASP</A>

    FWIW

Posting Permissions

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