ERROR MESSAGE "OVERFLOW"

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

I have used these queries for a long time. I guess something is in the table
that is wrong, but the query will not open, just gives me the message
"overflow".

Help, what am I looking for?
Annelie
 
Hi Annelie,

My guess would be that you have some type of calculated
expression that cannot work with some recent data in your
table. Some common problems include
calculations/functions that encounter problems as a
result of Null (which can be corrected by using the Nz()
function), or calculations which result in dividing by
zero. If neither of these seem to be the problem, you
can post back with the sql of your query and maybe
someone will have other ideas.

-Ted Allen
 
Back
Top