Comparing quarters annually

[fcmedina78]

I am trying to compare different years results for stores by quarter. I tried
using two queries and then creating a report using both queries but it won't
group by store. Anyone have any ideas

 

[Allen Browne]

Use a subquery to sum the figures for the previous year's quarter and the
same store.

If subqueries are new, here's an introduction:
http://allenbrowne.com/subquery-01.html

 

[KARL DEWEY]

Try this using your table and field names --
SELECT Format([SaleDate],"q") AS Quarter, Format([SaleDate],"yyyy") AS
[Year], [Sales-1].Store_ID, Sum([Sales-1].Amount) AS SumOfAmount
FROM [Sales-1]
GROUP BY Format([SaleDate],"q"), Format([SaleDate],"yyyy"),
[Sales-1].Store_ID;