|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 31st, 2009, 07:05 PM
posted to microsoft.public.access.queries
|
|||
|
|||
#Num! displayed in a control
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 
|
|
#2
March 31st, 2009, 11:00 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
#Num! displayed in a control
Maybe this --
=IIf([Total Complete week journal]=0 OR [Total Complete week journal] Is Null,0,[Total Average Calcium]/[Total Complete week journal])*100 "zufie" wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
