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
 
Back
Top