Numeric field overflow. (Error 3349)

C

CReitsma

I have created a query in Acc97. The first time I run the
query it runs fine. When I close the query results window
and try to run the query again I get a "Numeric field
overflow. (Error 3349)" error message. If I then edit the
query and then undo the edit the query runs fine once and
then fails on all subsequent runs. I do not have any
formulae that divide by a field that could generate a
divide by zero error. Any ideas out there as to what the
problem may be?
 
A

Allen Browne

Access is either misunderstanding the data type, or using a type that is too
small. Try adding CDbl() or CLng() around your calculated expression.

If there are Nulls, you will need Nz() inside that also. More information:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html
 

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
Numeric Overflow message 1
Query Error 4
Numeric Field Overflow when appending date - how to convert it to text 1
Need help on Numeric field overflow error 1
Access Query - Error 3349 1
The Numeric Field Overflow error with linked tables 2

Top