I see #Num! displayed in a control ( in a textbox of a subform).

What can I do to avoid this error?

Do I need to add =IIf([Total Complete week journal]=0,0, to the
beginning of the equation in my control source (of my textbox)?

-OR-

Do I need to delete *100 from my equation? (wich follows below)

=IIf([Total Complete week journal]=0,0,[Total Average Calcium]/[Total
Complete week journal])*100

I've tried both fixes before and each worked on its own or was I just
a lucky newbie Access programmer?

Your suggestions would be greatly appreciated!

Thanks,

John

zufie wrote:
Here's one link I found
http://groups.google.com/group/comp....b4c51868a4956c

On Mar 31, 8:05*pm, zufie <john.marru... (AT) illinois (DOT) gov> wrote:
Hi,

Make sure that controls on the subform are named as [Total Complete
week journal] and [Total Average Calcium], check if they are numbers
and [Total Average Calcium] <> 0. If they are string type, try with:

=NZ(CDbl([Total Average Calcium]), 0)/NZ(CDbl([Total Complete week
journal]), 0)*100

To avoid display of error (dividing with 0 or 0 divided with
something), you can add IIf() to check if both fields are <> 0 and
only then run above. If the numbers are Long Integer type replace CDbl
with CLng, if they are Integer type replace CDbl with CInt.

Regards,
Branislav Mihaljev
Microsoft Access MVP