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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numeric Field Overflow 1
Numeric Field Overflow Error 5
Access Overflow error 3
Limit on Number of Fields 3
Overflow Error 5
Overflow error on calculate field in query - Help Please 1
Using query to make a table 3
"Overflow" message in UNION query 4

Back
Top