Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    Wisconsin
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Overflow Error (2000)

    Arghhh...I am trying to run a query (the last of 3 queries which summarizes the other two). I keep getting "Overflow". Help didn't help me much in this case. The first two queries run just fine, the third one doesn't. What is the "usual" problem when this occurs? I have the same exact program in Office 97 with a slightly different dataset and it works just fine. My (dare I say) educated guess is that there is something wrong with the data, but I cannot find anything out of the ordinary.

    Thanks much!

  2. #2
    Star Lounger
    Join Date
    Aug 2001
    Location
    Seattle, Washington, USA
    Posts
    50
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Overflow Error (2000)

    I've gotten that MsgBox when trying to calculate via division. Seems Access doesn't want to divide by zero!

    So I used a very small number - like 1E-6 or smaller - to get around the problem.

    Anyway, if you're using divison, that's a possible culprit.

    HTH,

    Tom

  3. #3
    New Lounger
    Join Date
    May 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Overflow Error (2000)

    Hi,

    please verify you variable (if integer make it double) or check if you don't have a string format instead of a number.

    Regards,

    nick

Posting Permissions

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