Numeric Feild Overflow

J

J. L.

What do you do when you're trying to run an Access query
and you get the error message "numeric field overflow"?
 
C

Cheryl Fischer

You might want to check to see if you are doing some math involving fields
of Integer type that may return values outside the bounds of -32,768 to
32,767

hth,
 
H

HSalim

change the datatype to double using CDbl - for Double or CCur for Currency
eg: CCur(a*b)
 

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 Overflow Error 4
What is does "overflow" warning mean when trying to run a report? 2
Numeric Field Overflow 1
Overflow indicator in table 0
Numeric Field Overflow Error 5
Numeric field Overflow 1
Overflow error when appending data to SQL from Access 1
Help on Code Snippet Error {Val function} 6

Top