Division by Zero error / how do I find source?

[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

 

[Jeff Boyce]

Brook

On what (table or query) is the report based? Have you checked there
already?

 

[Guest]

Hello,

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

Brook

 

[Jeff Boyce]

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.