IIF Statement

G

Greg

Hi All,

Can anyone see what the problem is with this and hopefully assist.

=IIf([tblStaff.Type]="Wages",[total]*[ComAx],0) Or
IIf([tblStaff.type]="Commission",[total]*[commissions],0)

Thanks

Greg
 
A

Allan Murphy

This may work

=IIf([tblStaff.Type]="Wages",[total]*[ComAx],IIf([tblStaff.type]="Commission
",[total]*[commissions],0)

In this situation I would prefer using a CASE statement.
 
Top