Help summing IIf statement

[mikelev]

Any idea how to sum this?

=IIf(([wl]=0),0,IIf(([text80]=0),0,([wl]/[text80])))

Tried:

=Sum(IIf(([wl]=0),0,IIf(([text80]=0),0,([wl]/[text80]))))

It prompts me for "wl" value and "Text80" values?


It a never ending learning curve....

 

[THWatson]

mikelev
Have you tried
=Sum(Abs((IIf(([wl]=0),0,IIf(([text80]=0),0,([wl]/[text80])))))

Tom

 

[mikelev]

Howdy Tom:

Thanks for the response. Placing the code in the control souce caused the same result.

Cheers,

 

[dhookom]

You can't sum controls. I assume text80 is an default-named text box.

You can sum the expressions from control sources of controls. Pretend there aren't controls in the detail section.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]