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
Overflow error when appending data to SQL from Access 1
Numeric field overflow 1
Numeric field Overflow 1
Numeric field overflow 1
Why not numeric overflows? 5
Numeric Field Overflow 2
Numeric Field Overflow 1

Top