SELECT Detail.[Type], Detail.[Date], Detail.Return,
Detail.Sale, Year(Now()) AS [Current Year], DatePart("q",[Date]) AS [Calendar Quarter],
DatePart("yyyy",[ Date]) AS [Calendar Year], Format([Date],"qyyyy") AS [Quarter Year], Sum(Detail.Sale) AS [Total Sale],
Sum(Detail.Return) AS [Total Return], Format([ Date],"myyyy") AS [Month Year]
FROM Detail
GROUP BY Detail.[Type], Detail.[Date], Detail.Return, Detail.Sale, Year(Now()), DatePart("q",[Date]), DatePart("yyyy",[Date]), Format([Date],"qyyyy"), Format([Date],"myyyy")
HAVING (((Detail.[Type])="Purchase" Or (Detail.[Type])="Accrual" Or (Detail.[ Type])="Prepay"));