Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Referencing a Combo Box from a Crosstab Query (2003)

    On the startup form of the attached mdb, please select Maggio 2006 and open the Query14 query.
    How come you get the error message:
    <font color=red>The Microsoft Jet database engine does not recognize forms!mseledata!anno as a valid field name or expression.</font color=red>
    The syntax of Query14 seems fine to me.
    <font color=448800>TRANSFORM Sum(O1.ENER) AS SommaDiENER
    SELECT Sum(O1.ENER) AS totale
    FROM O1
    WHERE (((Year([giorno]))=[forms]![mseledata]![anno]))
    GROUP BY O1.ENER
    PIVOT Month([giorno]);</font color=448800>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Referencing a Combo Box from a Crosstab Query (2003)

    You must declare parameters in crosstab queries explicitly:

    Open the crosstab query in design view.
    Select Query | Parameters...
    Enter [forms]![mseledata]![anno] (exactly as in the Criteria line) in the Parameter column.
    Select Long Integer as Data Type.
    Click OK.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referencing a Combo Box from a Crosstab Query (2003)

    Thank you Hans <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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