IIf Statement in Query

[Matt205]

I have the following formula:

=IIf([Non Rent Guarantee]=0 Or IsNull([Non Rent Guarantee]),IIf([Customer Agents fees %]=0,Nz([Agents Fees %]/100*[RR]),Nz([Customer Agents fees %]/100*[RR])),"&quot

This formula works fine in a form but returns #Error in query.

Any suggestions?

Regards,
Matt

 

[tomschafer]

Try..
=IIf([Non Rent Guarantee]=0 Or IsNull([Non Rent Guarantee])=True,IIf([Customer Agents fees %]=0,Nz([Agents Fees %]/100*[RR]),Nz([Customer Agents fees %]/100*[RR])),"&quot