How to: Yearly Comparison Report

  • Thread starter Thread starter kfoll
  • Start date Start date
K

kfoll

Guest
Hi,
I have been racking my brain trying to figure out how to do this so maybe someone here has done something similar.
I am working with a database of product sales for our company. I generate various reports showing sales totals by month, year, etc. What I can't figure out how to do is to generate one which will separate and cross-tabulate the data by year, with totals going down for each month of the year. For example, I would like to display totals for January of 2002, 2003 and 2004 going across, and down for February, March, etc. A crosstab query doesnt work for some reason because Access seems unable to group by year going that way, and by month going down. It seems to only allow me to use the order date field once in a crosstab query. But I need to use it both ways, because we need to be able to compare sales in a particular month over a number of years to be able to project sales/customer buying trends for specific times of the year.
I am at present stuck with doing this the good, old-fashioned way, by typing the numbers into Excel. I would like to automate it more though, so if I could get Access to generate a query/report in the format I'm talking about above, it would save me a lot of steps in having to keep a thing like this up-to-date, and make it quicker to whip out reports.
If anyone can help me with this I'd much appreciate it.
 
Wow! That was fast! :D

Thank you sooooo much! I'm looking over your query as we speak, and I don't know why I didn't think of it before, except that I'm not as familiar with all the functions as I ought to be and Access help is an oxymoron. :( But this is exactly what I needed.
 

Users who are viewing this thread

Back
Top Bottom