criteria for 2 checkbox not work for both

leanpilar

Registered User.
Local time
Today, 22:43
Joined
Aug 13, 2015
Messages
94
need to filter a subform based of 2 checkbox on main form, all work but not for both checked
in this calculated field:
Code:
placeno: IIf(Nz([iznos])=False;0;-1)
this is the criteria:
Code:
IIf([forms]![Putninalogmjesec]![Check49]=-1;
IIf([forms]![Putninalogmjesec]![Check51]=-1;0 or -1;-1);
IIf([forms]![Putninalogmjesec]![Check51]=-1;0;is null))
if both are true the result 0 or -1 not work
 
In query criteria
 

Users who are viewing this thread

Back
Top Bottom