Prev: Adding Sequential numbers to a new feld in access table.
Next: jeramie bellmay
From: Alberta Rose on 21 Jan 2010 17:11
Could anyone help me with this formula? I need to know where to put the
coding that if there is no value in the selected txt's to return a zero.

=IIf([costcode]="013210" And [costtype]="05320",
[txtEstimatedCost]/[txtCraftLabEst], IIf([costcode]="020110" and
[costtype]="05320",[txtEstimatedCost]/[txtFirewatchLabEst],
IIf([costcode]="064201" and [costtype]="05320",
[txtEstimatedCost]/[txtCraftSuprLabEst],Null)))

From: Alberta Rose on 21 Jan 2010 17:16
SORRY FINGERS WERE TOO QUICK, REPOSTED THIS QUESTION.

"Alberta Rose" wrote:

> Could anyone help me with this formula? I need to know where to put the
> coding that if there is no value in the selected txt's to return a zero.
>
> =IIf([costcode]="013210" And [costtype]="05320",
> [txtEstimatedCost]/[txtCraftLabEst], IIf([costcode]="020110" and
> [costtype]="05320",[txtEstimatedCost]/[txtFirewatchLabEst],
> IIf([costcode]="064201" and [costtype]="05320",
> [txtEstimatedCost]/[txtCraftSuprLabEst],Null)))
>
 | 
Pages: 1
Prev: Adding Sequential numbers to a new feld in access table.
Next: jeramie bellmay