Quarterly Report query keeps using prior year data

[Gryphoune]

I have a query to pull the quarterly totals for a specific criteria but it keeps pulling data from Q4 of last year even when I try to limit it to the current year (as shown below). Can someone show me where this is going wrong? Shouldn't a quarterly report automatically limit the data to the current year or does it always just use the last four quarters?

TRANSFORM Sum([AUDIT NOTES].[ERROR AMOUNT]) AS [SumOfERROR AMOUNT]
SELECT [AUDIT NOTES].PROPERTY, Sum([AUDIT NOTES].[ERROR AMOUNT]) AS [Total Of ERROR AMOUNT], Year([Record Added Date])=Year(Date()) AS Expr2


FROM [AUDIT NOTES] LEFT JOIN PropertyGroups ON [AUDIT NOTES].PROPERTY = PropertyGroups.PropertyID
WHERE ((([AUDIT NOTES].RESOLUTION)="chrg"))
GROUP BY [AUDIT NOTES].PROPERTY, Year([Record Added Date])=Year(Date())
PIVOT "Qtr " & Format([Record Added Date],"q");


Thanks for any help.

[June7]

There is no criteria in the WHERE clause that limits records to current year.

I don't think the GROUP BY criteria accomplishes what you want.

But I don't use CROSSTABS and never seen GROUP BY on Boolean value, so could be wrong.