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
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