Access Query based on a form with multiple checkboxs

I can't seem to find any answers here for my specific problem. Maybe it's because I don't know what I'm looking for...

Anyway, I have an Access form that has about 30 checkboxes for each live facility we have and I need to run a query (which works perfectly) based on what boxes are ticked and a begin and end date which are also on the form.

This is the SQL I have (generated by the Query Wizard) that shows every single facility for every single date.

TRANSFORM Count(tblFilesProcessed.[File Name]) AS [CountOfFile Name] 
SELECT tblFilesProcessed.[Fac Alpha], tblFilesProcessed.[File Date], Count(tblFilesProcessed.[File Name]) AS [Total Of File Name]
FROM tblFilesProcessed
GROUP BY tblFilesProcessed.[Fac Alpha], tblFilesProcessed.[File Date]
PIVOT tblFilesProcessed.[File Type];