Query for specific checkboxes being checked in a custom field

[Casey Jones]

I have a custom field "Review" for my "core" Project. In that field are 4 checkboxs. "Tested" "Design Reviewed" "Code Reviewed" & "Needs Review".

I'm trying to set up individual filters for the design dashboard, Dev dashboard, and QA Dashboard. So I need a query that tells me if just "design reviewed" is unchecked, just "tested" is unchecked, and just "code reviewed" is unchecked when items are in Awaiting Acceptance.

I gotten this far,

Project = CORE AND "Review" is EMPTY AND status = "Awaiting Acceptance"

But this only tells me if none of them are checked where as I need indivdual checkboxes.

Please Help

[Ignacio Pulgar]

Just Tested is unchecked:

Project = CORE AND status = "Awaiting Acceptance" AND Review = "Design Reviewed" AND Review = "Code Reviewed" AND Review = "Needs Review" AND Review != Tested

[Jean-Francois Cartier]

so basically if you add one more option to the checkboxes you have to update your query?

It's far from being robust. Isn't there a way to get the checked/unchecked count on checkboxes?