Here is my situation:

I have a text box control. I want to check a field in my database and compare it to 0. The field is Car1 in the GARAGE table. If the value of Car1 is "0" the the text box control should display "NO" if not then "YES" The statement I have is as such:
Code:
=IIf([GARAGE]![Car1]=0,"NO","YES")
The control is on a report and when I run the report it prompts...