Hi, Im trying to build query that filters my recors by checkbox value in form.
I have field id_reason with numeric values, my idea is that when checkbox1 = 1, id_reason is filtred by value 11, when checkbox1 = 0, id_reason <> 11.
i tryed this formula as criteria in design grid:
IIf([forms]![form1]![check1]=1;[id_reason]=11;[id_reason]<>11)
but IIF is not operator, so it doesnt work...
Can anyone help with this one?
tnx
I have field id_reason with numeric values, my idea is that when checkbox1 = 1, id_reason is filtred by value 11, when checkbox1 = 0, id_reason <> 11.
i tryed this formula as criteria in design grid:
IIf([forms]![form1]![check1]=1;[id_reason]=11;[id_reason]<>11)
but IIF is not operator, so it doesnt work...
Can anyone help with this one?
tnx
Last edited: