I have a query and I would like to add a criteria that is an iif expression. This iff expression should be something like : if the chekbox in the form is checked than show all the record where this field is = 0; otherwise show all the record where this field is NOT 0.
iif ([Forms]![frm_Org]![chkbox]=No; 0; <>0)
I tried also NOT 0 instead of <> 0 but it seems that the iff expression and the <> or NOT expression that don't get along well.