Two IIF in a report

[BukHix]

I am trying to evaluate two IIfs in a report but have something wrong with the syntax. Here is what I have

=IIf([InvUM]="EA" And [InvRoLevel]<=6,6,12, =IIF ([InvUM="Qt" and [InvRoLevel] <= 220,220,440)

Basically the I want it to do the first evaluation if the InvUM field = EA and do the other evaluation if the InvUM = "Qt"

 

[KeithG]

I believe the syntax for the IIf function is

IIF(Expression to Evaluate, Value if True, Value if False)

 

[uncle-lai]

see if this works:

=Switch([InvUM]="EA", IIf([InvRoLevel]<=6,6,12), [InvUM]="QT", IIf([InvRoLevel]<=220,220,440))