ClickBank Products

How Do I Get Rid Of The #num! Error In Access When Taking The Difference Between To Columns Building A Report?

Q. when taking the difference between to columns building a report? I get the same error when doing it in Excel too.

Related posts:

  1. How Come I Get An Error Code Message, And Have To Send A Report To Microsoft, Every Time I Start Explorer?
  2. How to design a beautiful report header for cross report?
  3. How Do You Put In Error Bars In Excel 2007?

One Response to “How Do I Get Rid Of The #num! Error In Access When Taking The Difference Between To Columns Building A Report?”

  • Mikee_Co -October 1, 2009 at 11:48 pm


    This can be caused by various things that are not allowed mathematically. For instance “divide by zero” or attempting to perform math on a text field.
    You should use error trapping for things like “divide by zero”.
    If you have a column defined as text you could consider changing it to a numeric type like int or long. Or you could explicitly convert it using int() (or whatever). But this would only work if it’s actually a number. You can’t convert a text value of “three” without writing (or finding) a custom function.
    //

    VA:F [1.9.13_1145]
    Rating: 0 (from 0 votes)

Leave a Reply