C
ChuckW
Hi,
I have a fairly complex report that I am trying to design. I have a query
called SalesByMonth which lists the CustomerName and the fields for all
months since January 2005. I want to create a report that has CustomerName
and Year as row headers and the months as column headers. The report would
look like the following"
CustomerName Year January February March April May June................
ABC Corp. 2005 $100 $200 $300 $400 $500 $600
2006 $150 $250 $350 $450 $550 $650
2007 $225 $325 $425 $525 $625 $725
Can anyone help me with this?
Thanks,
I have a fairly complex report that I am trying to design. I have a query
called SalesByMonth which lists the CustomerName and the fields for all
months since January 2005. I want to create a report that has CustomerName
and Year as row headers and the months as column headers. The report would
look like the following"
CustomerName Year January February March April May June................
ABC Corp. 2005 $100 $200 $300 $400 $500 $600
2006 $150 $250 $350 $450 $550 $650
2007 $225 $325 $425 $525 $625 $725
Can anyone help me with this?
Thanks,