Iif statement gives #Name? error

[coach.32]

I have created an Iif statement on my text box in a report.
=IIf([Acty_Priority]="3-Medium" And [Acty_Cmplxty]="Low",1,0)
The 2 fields are the headings in a query. Why do I receive a #Name? error when I view the report? The name of the query is "Stats". Thank you in advance for any help. The text box and the report is not bound to the query.

 

[pbaldy]

Make sure a textbox doesn't have the same name as one of the fields, which can screw Access up.