Query Error "OVERFLOW"

[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?

 

[Timothy C. Doherty]

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>).