SQL statement in report not working for all years

[krc777]

Hello-
I have the following sequel statement in a report:

TRANSFORM Sum([CHValues]) AS [SumOfCHValues] SELECT (Format([Months],"MMM 'YY")) FROM [Chart Query 1st year Adj] WHERE [pmtyr] = 2004 GROUP BY (Year([Months])*12 + Month([Months])-1),(Format([Months],"MMM 'YY")) PIVOT [IPR];

When the report displays all years and types are shown not just 2004.