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 forthen checking it for if ran last month as the current reporting month withCode:<>Month(Date()) or 5 or 6they match.Code:<>MonthDate())-1 or 5 or 6
However when I try to test couple months priorand yet another month prior to thatCode:<>Month(Date())-2 or 5 or 6they do not matchCode:<>Month(Date())-3 or 5 or 6