Find unchecked checkboxes

[EllenM]

Hello,
I have a table with text field and 5 checkboxes in Access 2003. I'd like to
find all the records with all the checkboxes unchecked.

Thanks in advance for your help,
Ellen

 

[KARL DEWEY]

Try this --
SELECT [TextBox]
FROM YourTable
WHERE [Check1] + [Check2] + [Check3] + [Check4] + [Check5] = 0;

 

[Jerry Whittle]

SELECT CheckBoxes.*
FROM CheckBoxes
WHERE ([YesNo1]+[YesNo2]+[YesNo3]+[YesNo4]+[YesNo5]) = 0 ;

Put in the correct table and field names.

 

[EllenM]

Thanks so much!!! I've actually been trying to figure this out for some time.

 

[KenSheridan via AccessMonster.com]

To avid placing reliance on the implementation:

SELECT *
FROM [YourTable]
WHERE NOT([Check1] OR [Check2] OR [Check3] OR [Check4] OR [Check5]);

The expression in parentheses will only evaluate to FALSE if none are TRUE.

Ken Sheridan
Stafford, England