Crosstab query with no aggrigation

[TimTDP]

I have the table "tblProductionForecast" with the following fields:
ProductionForecastProductId
ProductionForecastMonth
ProductionForecastQuantity

I want to show this in a report, similar to an spreadsheet, with:
ProductionForecastProductId = Rows
ProductionForecastMonth = Columns
ProductionForecastQuantity = Data

I thought of using a crosstab query like this:

TRANSFORM avg(tblProductionForecast.[ProductionForecastQuantity]) AS AvgOfProductionForecastQuantity
SELECT tblProductionForecast.[ProductionForecastProductId]
FROM tblProductionForecast
GROUP BY tblProductionForecast.[ProductionForecastProductId]
PIVOT tblProductionForecast.[ProductionForecastMonth];

but I don't want the average of ProductionForecastQuantity. I want the actual value!

Is a crosstab query the wrong method to use?
If no, how do I show the actual value of ProductionForecastQuantity
If yes, how should I create the report?

Many thanks in advance

 

[jdraw]

See if this free tutorial helps
http://www.datapigtechnologies.com/flashfiles/crosstab.html

 

[TimTDP]

Unfortunately not!

 

[jdraw]

Could you mock up a picture (jpg) of a few rows of your desired output?

 

[TimTDP]

Graphic attached

Many thanks