I have more information.
I have a table and it is set up in this way....Item,Description,Frequency,MHRS,Shift, Area, PM_W1,PM_W2,PM_W3 ALL THE WAY TO PM_W52. I need a weekly report so if I choose PM_W1 (criteria=yes) and the Area (criteria=1) then I get the report that looks like this:
ITEM...