Multiple row report

[mfallon]

Hi,

I would like to create a report that looks like this:

_______________ 2007| 2008| 2009| 2010| 2011|
Product 1
Production rate| 4.5| 2.5| 4.5| 3.5| 2|
Conformanc rate| 3.4| 6| 1.5| 1| 1.6|
Shakedown rate | 2.6| 1.5| 1.5| 2| 2.5|
Product 2
Production rate| 3.4| 6| 1.5| 1| 1.6|
Conformance rat| 2.5| 0.6| 2.3| 1.9| 2.1|
Shakedown rate| 3| 1.5| 1.5| 2| 2.5|


Currently I have a query with all of the values shown above. I am able to get a report with product by year and the rates by year, but I would like to show product and rates for each year. Any suggestions?

 

[WayneRyan]

M,

This is a pretty common topic here.

Hope this link helps:

http://www.access-programmers.co.uk/forums/showthread.php?t=126338&highlight=function+wayne

Wayne