Crosstab query...

[thewabit via AccessMonster.com]

I am frustrated with this one...

I have a crosstab query used to display results on a graph. I want to filter
"risklevel" depending on what is selected in a combobox using a value list.
When I put in the filter and run the query, I get the error "The Microsoft
Jet Database Engine does not recognize [Forms]![frmLOSA_Chart_Trend]![risk]
as a valid field name or expression"

Here is the SQL....

TRANSFORM Sum(qryLOSATrend_Risk.RiskLevelQTY) AS SumOfRiskLevelQTY
SELECT qryLOSATrend_Risk.OBMonth
FROM qryLOSATrend_Risk
WHERE (((qryLOSATrend_Risk.RiskLevel)=[Forms]![frmLOSA_Chart_Trend]![risk]))
GROUP BY qryLOSATrend_Risk.OBMonth
PIVOT qryLOSATrend_Risk.RiskLevel;


Thanks!

 

[Duane Hookom]

You must specify the data type of your parameters in a crosstab query.
Select Query->Parameters and enter:
[Forms]![frmLOSA_Chart_Trend]![risk] (the data type here)

Duane Hookom
MS Access MVP

 

[thewabit via AccessMonster.com]

Who in the heck makes these rules!? Us beginners don't have a chance. I would
have never figured that out.

Thanks Duane...works great!

You must specify the data type of your parameters in a crosstab query.
Select Query->Parameters and enter:
[Forms]![frmLOSA_Chart_Trend]![risk] (the data type here)

Duane Hookom
MS Access MVP

I am frustrated with this one...

[quoted text clipped - 18 lines]

Thanks!