General discussion

Locked

#Num! in Access2000 report

By Greyknight ·
I have a created a report in Access 2000 that get data from our Unix acounts application using ODBC. Sometimes however the data is the value "0" in 2 boxes that are set to be divided by each other. This gives you the answer of #Num! in the calculated box. I have tried conditional formating and using Iif (Immediate If) to tell the box not the display if this in the answer, but have had no success as yet. Any clues!

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

#Num! in Access2000 report

by Larry H. In reply to #Num! in Access2000 repor ...

Use the Iif() test on the denominator of the expression to prevent Access from trying to divide by zero. Something like this:

Iif([Denominator]=0,"",[Numerator]/[Denominator])

Collapse -

#Num! in Access2000 report

by Greyknight In reply to #Num! in Access2000 repor ...
Collapse -

#Num! in Access2000 report

by Greyknight In reply to #Num! in Access2000 repor ...
Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums