B
Bill
I am looking for a way to write a nested IIF statement in the control source
of a bound control in a data access page that will produce a calculated
result. Also, is there a way to work around the problem of using calculated
controls in calcylated controls in a Data Access Page?
Here is an example of a working nested statement I use in a Form. i need to
use this in the Data Page somehow. it is invalid as written for the Page but
works fine in the form.
MaterialCost1:IIf(([Material]="EPP"),[Weight1]*([MaterialCostPerLB]/16)/.98,IIf(([Material]="ARCEL"),[Weight1]*([MaterialCostPerLB]/16)/.91,[Weight1]*([MaterialCostPerLB]/16)/.98))
of a bound control in a data access page that will produce a calculated
result. Also, is there a way to work around the problem of using calculated
controls in calcylated controls in a Data Access Page?
Here is an example of a working nested statement I use in a Form. i need to
use this in the Data Page somehow. it is invalid as written for the Page but
works fine in the form.
MaterialCost1:IIf(([Material]="EPP"),[Weight1]*([MaterialCostPerLB]/16)/.98,IIf(([Material]="ARCEL"),[Weight1]*([MaterialCostPerLB]/16)/.91,[Weight1]*([MaterialCostPerLB]/16)/.98))