I have three feilds which have tick boxes. I need a query which would not show if one of a particular two were ticked. The fields are Holiday Sick and the other is completed. If completed was ticked it would not show and if completed was not ticked and one of the other was ticked ie Sick or Holiday it would not show.
So if an employee was ticked to say he had completed it would not show. If an employee was not ticked completed but if either Holiday or Sick was ticked it would not show in the query.
I have tried true or false but it did not work as i think i have missed a bit out of the query