Division by Zero

D

Danny

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!
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top