Overflow

[iuphim]

I ran the queries in my database and it's giving me an error of "overflow". There's only about 1500 records. Does anyone know what this means?

Thanks.

 

[Scooterbug]

A bit vague there....

Are you doing any calculations on the query? Any chance of you posting the database?

 

[namliam]

Overflow means something is to big... I.e. You are displaying a BIT (0 or 1) with a value of 2, that would generate an overflow error.

Simular but bigger limit values exist for each of the number formats, look them up in the access help and see if that helps you to resolve this issue for you

 

[NigelShaw]

Hi,

i went through an overflow stage.......

i found that it ended up happening when i tried to calculate certain numeric values that had been declared as different types i.e. Integer, Long, Variable etc.

my main issue was calculating dates. as soon as i made sure all figures being used were of the same object type, my overflow issues were no more


Nigel

 

[MSAccessRookie]

I would like to add that in some circumstances you can get an overflow if you divide by a Zero or NULL value, so if the other suggestions do not check out, you might want to check out the data and see if there are any issues.

 

[gemma-the-husky]

what's the exact error message - that would be useful

I would have thoughtthe most likely candidate is a number becoming too big for the datatype

ie a long going over 2 billion, or an integer going over 65000.

 

[The_Doc_Man]

Another way to get caught is on a data type that allows really big numbers being forced into smaller data type in an unobtrusive way.

For instance, storing a field originally of type DOUBLE into something that is type LONG can often give you an overflow if the DOUBLE was pretty big, like > 2 billion. Not an overflow for the DOUBLE but a guaranteed overflow for the LONG.

 

[edster]

I would like to add that in some circumstances you can get an overflow if you divide by a Zero or NULL value,

I've had this before too, drove me nuts for ages before i worked it out.