K
KrispyData
I am trying to use this funcition in a query. Access is giving me the
message that I put in the subject line of this question. What appears to be
wrong with the function? The reason I am doing this is because I want a 0 to
appear instead of error message if the denominator is 0.
IF([t_OCProfit_FINAL]![NF_Sales]=0,0,([t_OCProfit_FINAL]![NF_Sales]/[t_OCProfit_FINAL]![OC_Sales]))
message that I put in the subject line of this question. What appears to be
wrong with the function? The reason I am doing this is because I want a 0 to
appear instead of error message if the denominator is 0.
IF([t_OCProfit_FINAL]![NF_Sales]=0,0,([t_OCProfit_FINAL]![NF_Sales]/[t_OCProfit_FINAL]![OC_Sales]))