Results 1 to 4 of 4

Thread: Crosstab Query

  1. #1
    Join Date
    Jan 2010
    Posts
    32

    Unanswered: Crosstab Query

    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!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6

  3. #3
    Join Date
    Jan 2010
    Posts
    32
    Thanks Paul

    Got it...it works now! All these rules. Us beginners don't have a chance.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    LOL! Glad we got it sorted out.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •