Query Error "OVERFLOW"

  • Thread starter Thread starter jelena
  • Start date Start date
J

jelena

Please Help I am going crazy.
I have a query calculating simple arithmetic calculations
and now all of a sudden when I run the querry I get a
message with the following:
"Overflow"

and that is it.
the db is 26 MB. When I delete columns in the query it
runs again, but this is not practical. I compacted and
repaired the db.
DOES ANYONE KNOW WHY THIS IS HAPPENING?
 
Overflow typically occurs when an integer data type is assigned a value
larger than the 2-byte data type can store (values can range from -32,768 to
32,767). Try converting your source fieldsto Long Integer data type, or
explicitly type-ing your calculated result using CLng(<expression>).
 
Back
Top