See attached
Views: 0 Size: 50.1 KB">Collegiates.zip

I need to have the numbers match from Query1 and ByFiscalYear when reporting in the month.

It works for
Code:
 <>Month(Date()) or 5 or 6
then checking it for if ran last month as the current reporting month with
Code:
<>MonthDate())-1 or 5 or 6
they match.

However when I try to test couple months prior
Code:
 <>Month(Date())-2 or 5 or 6
and yet another month prior to that
Code:
 <>Month(Date())-3 or 5 or 6
they do not match