Discussion Locked

Access 97: Div by 0's

0 helpful
8 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a report that trys to calculate the percent of two fields, but when one of the fields has a 0 value I get an error in on the report divide by 0. What is the best way to change the error to a 0 value. This error also causes me to be unable to export to Excel Please Help!

8 replies

by mhguda

You can write a filter in your access query that only calculates the percentage if you have a non-zero value, and gives a zero otherwise.

This discussion is closed to new replies.