What's an Overflow from a MS Access 2000 query?

[DaverD]

What does an Overflow error mean when I run a Select query?

The query is based on a large database of baseball statistics. I am asking for batter information. If I ask for only information already stored in the table - all is ok. If I take the same query and add a computed column, I get an overflow.

Any clues?

 

[scriverb]

The calculated column has a division in the expression that is causing the over-flow. Post the field names and field types and the actual query expression. Could be a division by zero or a null value also in a record.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[DaverD]

Thanks Bob.

I read your response and thought, "Why didn't I see that?"

You see, I was generating results with the query based on specific players and all was fine. When I left the players column blank - asking for all players, I got the Overflow and I just couldn't figure out why. I thought perhaps it was related to the number of records needing the calculation versus available memory that was causing me the problem. However, it got more strange to me as I reduced the number of field columns to just one and calculated columns to just one and still got the error. (I thought this would minimize this capacity issue I thought was taking place.)

Anyway, by simply putting in a >0 in the column used in the denominator of the calculations fixed the problem.

Thanks again.

By the way, why was the error an Overflow as opposed to something telling me a divide-by-zero error?

Not important but just curious.

 

[scriverb]

I believe that the error you received is a generic error and can be generated by the divide by 0. I guess I actually never have received the "divide by zero" error but that usually is the cause of your error message.

Glad that I could get pointed in the right direction.

Bob Scriver

Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???