Error in MS Access query that is overflow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sir / Madam

I'm Viveck from India.

I'm using office 2003 in MS Access i've got an Error, the message is Overflow
Please give me the quick reply.


Thank you
 
We need more than that. Overflow where ?
If it is in some code, then post the code please.
 
Hi Viveck,

As Dennis mentioned, it is hard to say without having details, but overflow
generally results from a query operation that provides a result that is too
large to fit in the underlying field size. Often it is the result of
division by 0, or by other calculations that provide a result too large for
the field size. In the case of the latter, sometimes you can get around the
problem by using CLng() or CDbl() to coerce the field size to either of those
(as appropriate).

Hope that helps. If not, please post back with more details.

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 when appending date - how to convert it to text 1
Numeric Field Overflow Error 5
Overflow error on calculate field in query - Help Please 1
Overflow Error 5
Numeric Field Overflow 1
Access Overflow error 3
"Overflow" error in an Access 20003 query 3
"Overflow" message in UNION query 4

Back
Top