Need Help with Sale Report

C

ChuckW

Hi,

I have a query that has records in it which include CustomerName,
CustomerType, Jan05Sales, Feb05Sales,....Jan07Sales. So it is monthly sales
for the past two years. I want to create a report that Monthly Sales as
field or column headers, CustomerName and Year as row headers and then group
by CustomerType. So the format would look like the following:

CustomerType A
CustomerName January February March April May June July.....December Total
Joe Smith 2005
2006
2007
John Jones 2005
2006
2007

Can someone help me with how to format this?

Thanks,

Chuck
Chuck W
 

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

Similar Threads

Create report with three rows of data representing years 7
Summing by year in a cross tab query 2
Calculating data from records results of a cross tab query 2
6 month time bracket in report header 2
Month days over a time period 5
Trying to look like this 8
Need to pivot my data from columns to rows 1
How do I custom sort records in a report? 2

Top