Report Comparing Quarters Annually

[fcmedina78]

I am trying to create a report with a graph that compares earnings by quarter
then groups them by store. An example would be:

Store2
2007 Quarter 1 $15,000
2008 Quarter 1 $22,000

This information is coming from a table with the following fields: Store
Number, Date, and Dollar Amount.

I have tried creating two queries one for each year but I can't get the
information to line up in the report for each store.

 

[Klatuu]

First, don't use Date as a name. It is a reserved word an is very likely to
cause problems, especially since you will be using it in caluclations in a
query.
You need to use a query on that table with two calculated controls.
RptYear: Year([TranDate]) RptQtr: DatePart("q",[TranDate])

That will give you the year and the quarter for each record. You can then
use the report's sorting and grouping to roll the numbers up however you need
them.