False parameter query

[Access_Novice]

In the attached document, I have screen shots of my query. In my query I have a calculated field which uses an IIF formula. When I try to run the query, Access seems to think that I am trying to do a parameter query even though I am not.

What is wrong with my syntax that is causing Access to expect a parameter?

[June7]

First, cannot compare to Null. Review Error 5 in this article http://allenbrowne.com/casu-12.html

You don't get prompted for PaidAmount1? I don't see any reason for either to be prompted. Odd.

[Access_Novice]

First, cannot compare to Null. Review Error 5 in this article http://allenbrowne.com/casu-12.html

You don't get prompted for PaidAmount1? I don't see any reason for either to be prompted. Odd.

Thank you for your reply. I wondered about PaidAmount1. So I entered a value after the first prompt, then I was prompted for PaidAmount1.

In short, I am trying to find a way to display a zero value in cases where there is a null. I think Error 2 in your link is the answer. Thank you for the link.