Numeric Overflow

[mlr0911]

I am using a linked Excel sheet that has formulas linked to fields in Access. Some of my cells (formulas) don't have any information that is being auto populated, therefore empty; however, Access is reading the cells and giving an error message "Numeric Overflow".

Does anyone have a solution to this?

Thanks for your help.

 

[statsman]

Access has a very difficult time multiplying zero times zero or dividing zero into zero.

If your fields are blank and set to number, Access reads them as a zero.

Do a search in the forum on "mulitplying by 0" or "dividing by zero". There is a process for doing this but it escapes me at the moment.

 

[Rabbie]

If a field can be Null it is good practice to use the nz() function which forces it to 0 if you are using it.

If you have a field feined as an integer and it goes outside the range 32767 to -32768 then you might get "Numeric Overflow. Try redefining it as "Long integer"