Form Chart Expression??

[ppabs]

Hello all,

Originally, my goal was only to select all records in the "forecast_info" table where the table field "f_model" was equal to the content of a form field "v_model". I was able to achieve this with the following query.

PARAMETERS [Forms]![vehicle_info_form]![v_model] Text ( 255 );
SELECT forecast_info.f_model, forecast_info.f_year, forecast_info.f_production, forecast_info.f_sales
FROM forecast_info
WHERE (((forecast_info.f_model)=[Forms]![vehicle_info_form]![v_model]));

I took the results of this query (called QUERYmodelname_forecast) and displayed them in a form chart. One chart for sales (f_sales) and one chart for production (f_production). Here is the SQL behind the Production form chart:

TRANSFORM Sum(QUERYmodelname_forecast.f_production) AS SumOff_production
SELECT QUERYmodelname_forecast.f_year
FROM QUERYmodelname_forecast
GROUP BY QUERYmodelname_forecast.f_year
PIVOT QUERYmodelname_forecast.f_model;

Now my dilemma... now my task is to create this same graphs with the same original criteria of the first SQL. However, there are now 2 production forecasts . In other words, there will be "f_productionA" and "f_productionB". I need to apply the sum of "f_productionA" and "f_productionB" in place of "f_production" in the chart. I'm at a loss for how to go about this. I tried creating expressions and dabbled in a Lookup Wizard type field but didn't get very far with either. What do you guys suggest as the best way to accomplish this? Hopefully I explained clearly...

Thanks in advance.

[PianoMan64]

TRANSFORM Sum(QUERYmodelname_forecast.f_productionA) + Sum(QUERYmodelname_forecast.f_productionB) AS SumOff_production
SELECT QUERYmodelname_forecast.f_year
FROM QUERYmodelname_forecast
GROUP BY QUERYmodelname_forecast.f_year
PIVOT QUERYmodelname_forecast.f_model;