Sorry for what may end up being a fairly simple solution, but I can't seem to get rid of the #Num! error on my formula. Looking at previous posts It seems I may not have the best formula so I hope you can help.
I have a query I run that contains all of my formulas. One of them is:
IIf([FAMILY TOOLING]=Yes,(2*([QTY PER ANNUM]/[PRODUCTION PER HOUR])),([QTY PER ANNUM]/[PRODUCTION PER HOUR]))
From previous post it would appear I have another divisor if it's false when I should have a 0, but I need that other set of figures as well. This works great as long as there are data in all of the feilds, but if one field is blank I get the #Num! error.
Is there anyway to stop this from occuring?
Thank you for your help.
I have a query I run that contains all of my formulas. One of them is:
IIf([FAMILY TOOLING]=Yes,(2*([QTY PER ANNUM]/[PRODUCTION PER HOUR])),([QTY PER ANNUM]/[PRODUCTION PER HOUR]))
From previous post it would appear I have another divisor if it's false when I should have a 0, but I need that other set of figures as well. This works great as long as there are data in all of the feilds, but if one field is blank I get the #Num! error.
Is there anyway to stop this from occuring?
Thank you for your help.