Nested IIF

[uttwo]

Hi

how would one go about nested IIF

New Sal : IIf([emplsalaryaa]>80000,([emplsalaryaa]+([emplsalaryaa]-80000)/(100)*9)+7713.98)

i have the above but i need to put one more

iif

i have tried , IIF but it does not work

i don't know why?

Asad

 

[boblarson]

New Sal : IIf([emplsalaryaa]>80000,([emplsalaryaa]+([emplsalaryaa]-80000)/(100)*9)+7713.98, IIF([whateverfieldyouwant]=WhateverCriteria, value if true, value if false))

 

[jfgambit]

Here is one I use, see if this is any help...

IIf([category] Between 0 And 1,"Current",(IIf([Category]=2,"Active","Legacy")))

This returns the following

Category 0 = Current
Category 1 = Current
Category 2 = Active
Category 3 = Legacy
Category 4 = Legacy

If you give us the other iif statement we may be able to help you place it correctly in the query.

 

[uttwo]

Thanks a lot it works!!!

Your help is much appreciated