Div/0 Error In Access

Question

I have a form that displays a Div/0 error when one the required fields is left at 0.  The calculation is done in the background query.  Is there a way to have the form display a blank or a N/A when a Div/0 error occurrs?

Answer 1

The following should return a zero if Total Hours is zero:

IIF([Total Hours]>0,[Total Quantity]/[Total Hours], 0)

or to return 'N/A':

IIF([Total Hours]>0,[Total Quantity]/[Total Hours],"N/A")

The former might be better if you need to do any further operations on the value e.g. summation over a set of rows in a report.

PS:  The above should work in a query, but not in code.

Answer 2

I am merging an Access DB with word. When I open the Access DB from Word I see the the Access entries are surrounded by <div> and </div>. What's up with this?

Answer 3

Thanks so much Ken, that did the trick!

Answer 4

Ken:  the expression in the query field is

Task Productivity Rate: [Total Quantity]/[Total Hours]

Answer 5

What is the expression in the query?  You should be able to amend it to incorporate an IIF function call so that the division by zero error is avoided.  Or you can write a little function which does the same.