Error in MS Access query that is overflow

V

Viveck

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
 
D

Dennis

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

Ted Allen

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
 
Top