Division by Zero

[Guest]

Dear all,

I have problem to my query. My query is to retrieve data which it's percent
is >80%.

But I got the error "Division by zero" when I put the condition >=80% in the
query. There is no problem to run the query if the condition is not inserted.

Please Help.

Thanks!

 

[Duane Hookom]

I expect your query might be "dividing by zero" someplace. Make sure you
filter out all records where the denominator is zero or change your
calculation.