G
Guest
I have a query that is using an expression to calculate price and it
generates a "#Error" entry when it encounters a record which has a zero as
entries for the expression:
Exp_Price_byArea: Nz(([x_Q_PM_sum_Val_Calc_01]![SumOfExpr1]);0) /
Nz(([x_Q_PM_sum_Val_Calc_01]![SumOfQ_2006]);1)
I tried to use Nz function to force a 1 in the denomenator but it does not
work can some one help with the above problem, thanks.
generates a "#Error" entry when it encounters a record which has a zero as
entries for the expression:
Exp_Price_byArea: Nz(([x_Q_PM_sum_Val_Calc_01]![SumOfExpr1]);0) /
Nz(([x_Q_PM_sum_Val_Calc_01]![SumOfQ_2006]);1)
I tried to use Nz function to force a 1 in the denomenator but it does not
work can some one help with the above problem, thanks.