Query Filter with multiple checkboxes

[Chalkie42]

Hi Folks.

I have a select query that has 10 columns which are checkboxes (yes/no) from the original table. I can apply filters for individual columns but I want the query to show records with ANY of the boxes checked and only omit those with NO boxes checked.

I have spent the whole atfernoon researching the forum but I can't find what I need. Help much apreciated.

Chalkie.

 

[pbaldy]

Try

WHERE Field1 = True OR Field2 = True OR ...