Nested IIF

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

=IIf(IsNull([porhora]),[mensual],IIf(IsNull([salario_otro]),[porhora],[salar
io_otro]))

If have the next IIF formula in my report

=IIf(IsNull([porhora]),[mensual],IIf(IsNull([salario_otro]),[porhora],[salar
io_otro]))

This formula works, it shows the fields porhora and mensual but not the
field salario_otro?

What is wrong in the formula that it not shows the field salario_otro?
How should the formula look like?
Finally the result should be:

Herman $5.15
Ivan $6.00
Ivette
Bill $ 1155.00
Isaac Commission

Hermie
 
First, is there an occasion in the underlying table/query
where the [porhora] is not null and [salario_otro] is not
null?
If these two conditions are not both met [slario_otro]
would never be printed.
Fons
 
Back
Top