Report Comparing Quarters Annually

F

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.
 
K

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top