#Num! displayed in a control

  • Thread starter Thread starter zufie
  • Start date Start date
Z

zufie

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
 
Maybe this --
=IIf([Total Complete week journal]=0 OR [Total Complete week journal] Is
Null,0,[Total Average Calcium]/[Total Complete week journal])*100
 
Back
Top