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.