Division by Zero error / how do I find source?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

good day all,

I have a report that I'm trying to open that i'm getting a Division by Zero
error, how can I determine what would cause this?

Thanks,

Brook
 
Hello,

its based on qryinvcalculations, and I have looked but don't know what to
look for?

Brook
 
Brook

If the error message is any indication (not always a safe bet), your query
has an expression with a division in it, AND the denominator, for at least
one of your rows, is 0 (zero).

Try listing the fields without doing a division and see if you can spot the
0.

One approach would be to exclude those rows with a 0 value in the field.
 
Back
Top