J J. L. Sep 25, 2003 #1 What do you do when you're trying to run an Access query and you get the error message "numeric field overflow"?
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 Sep 25, 2003 #2 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,
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 Sep 25, 2003 #3 change the datatype to double using CDbl - for Double or CCur for Currency eg: CCur(a*b)
