Multiple checkbox filtering & Clearing

[Havvix]

Hello I have 2 questions,



1. I have a table with 5 check box columns, I would like to filter the records that have no check marks in any of the columns, but keep the records if there it is checked off in any of the columns. Is this possible? I am a beginner with access.
2. Is there a way to removed checked entries all at once so i have a clean slate to use for a different report?

Thank you in advance

[June7]

1. Try criteria under each yes/no field: =True
Put each criteria on separate OR criteria rows

2. Run UPDATE query to set each yes/no field to False

[Havvix]

Thanks that did it, Is there a way to keep the report from changing after I make it? I made a report and ran the Update query but it delete all the information from the report

[June7]

Options:

Save the report as a PDF.

Change your database structure so report can be recreated without having to reselect the yes/no fields for each record.