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)
 
Top