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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF function nor work good 2
IIF formula 6
Nested IIF statements 3
Eliminating blank lines 4
Conditions with a nested IIF 2
Nested IIf and IsNull 1
Using IIF in Report 2
IIF Function in Update Query HELP! please :) 0

Back
Top