Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Posts
    395

    Unanswered: VB Overflow error

    What does 'Overflow' means? It's highlighting the code in opening the report.

    There's a field in the report which I converted the calculated value back to integer using CInt function in the SQL statement. But I don't understand if that's the reason or why?

    Thanks!!

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Overflow

    Theres a few articles on msdn about overflow: i.e.

    http://support.microsoft.com/default...en-us%3B298984

    Search their knowledge base, may help

  3. #3
    Join Date
    Feb 2003
    Location
    Wichita,KS
    Posts
    44
    Most likely your integer is greater than 32,767 which is the maximum value. Use Long Integer (or Double it the number is really big) instead.

  4. #4
    Join Date
    May 2002
    Posts
    395

    Overflow error

    I know what caused the "Oveflow problem. I used Cint function in the SQL statement to convert the result from single to integer for calculated field. This field needs to be integer in the report. By using CInt function it generated this error.
    One of the fields I used to do the calculation has these properties in the table: Single, Percent. Therefore, the result field produce a float value. I want to convert this value to integer. But I don't see why this will give me error when the result is a calculated field?

    I need some assistance. Thanks!!

Posting Permissions

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