assuming that the checkbox controls on the form are unbound (the
ControlSource property of each control is blank), try the following:

set up the criteria as OR references, not AND references. to do this, put
the reference on the *first* criteria line of the first Yes/No field. then
move over to the next Yes/No field, and put the reference criteria on the
*second* criteria line - leaving the first line blank. then move over to the
next Yes/No field, and put the reference criteria on the third criteria
line - leaving the first and second lines blank. continue in this fashion,
"stair-stepping" the reference criteria, until you've added criteria for
each Yes/No field tat refers to the corresponding checkbox on the form.

add a command button on the form, to run the query. add code to the button's
Click event procedure, as

   DoCmd.OpenQuery "NameOfQuery"
   With Me
       !chkTime1 = Null
       !chkTime2 = Null
       !chkTime3 = Null
       !chkTime4 = Null
   End With

substitute the correct name of the query and the correct names of the
checkbox controls on the form, of course (adding or deleting lines of code
as needed, to handle all the checkbox controls on your form). the above code
opens the query, obviously; if you want to open a form or report that's
bound to the query (usually preferable to opening a query directly), then
change the Open command accordingly.

note that i'm not endorsing your non-normalized table design, and i do
recommend that you consider normalizing your table structure before you move
forward. you'd have to change the form design to work with a normalized
table, but IMHO that's an an acceptable trade-off for a correctly designed
structure.

hth