Parameter query using criteria and IIf function

[Sanchi]

I need to create a query using inputs from my form, it's check button. What I wish to do is when the check button is ticked it will show me open records or show me all records. Open records are those for which closure date is null.

Expr1: IIf([forms]![Main]![OpenOnly]=True,IIf(IsNull([QA Closure Date]),1,0),1)

This code is working well but I am not understanding the '1' in the end, also I have to put a 1 in the criteria section of the design view. Is there a thing that Access assigns 1 to all the records by default or is it because of my code?

[twinnyfo]

Sanchi,

Welcome to Bytes!

It appears that your criteria expression is more useful for counting records, but it also works to select records, too—I have used such designs in the past also. By having the expression resolve to either a 1 or a 0, having the 1 in the Criteria line allows you to select only those records which resolve to 1 which, in this case is those records in which OpenOnly is checked and Closure date is Null OR OpenOnly is Unchecked.

However, an easier expression might be:

(([forms]![Main]![OpenOnly] And IsNull([QA Closure Date]) Or Not [forms]![Main]![OpenOnly])

With True in the Criteria section.

I’m not sure if any of this answers your question, but I’m not sure of the exact question.

Hope this hepps!