Limit Graph Result to Past 12 Months 1

[uncleG]

I am using the following Code to generate a Graph on a Form.

TRANSFORM Sum([AvgScore]) AS [SumOfAvgScore] SELECT (Format([EvalDate],"MMM 'YY")) FROM [tblSuppScores] GROUP BY (Year([EvalDate])*12 + Month([EvalDate])-1),(Format([EvalDate],"MMM 'YY")) PIVOT [scConID];

What must I change to limit the display period to the past 12 months only?

Thanks, Uncle G

 

[Golom]

FROM [tblSuppScores]
WHERE [EvalDate] >= DateAdd ( "m", -12, Date() )
GROUP BY ...