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 field overflow†(Error 3349) 0
Access Query - Error 3349 1
Query Delete and append 0
The Numeric Field Overflow error with linked tables 2
Overflow error on calculate field in query - Help Please 1
"Overflow" message in UNION query 4

Top