Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Oct 2009
    Posts
    13
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Setting Criteria for a crosstab query

    I am working in Access 2002. I am trying to run a crosstab query with the criteria for one of the fields being pulled from a form. However I get the error message"The Microsoft Jet database engine does not recognize '[Forms]!FundsReports]![SelClientRpt]' as a valid field name or expression.". This works in a Select Query.
    Is there some way to pull the criteria for a crosstab query field from a form?

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Have you defined [Forms]!FundsReports]![SelClientRpt] as a parameter in the query?

  3. The Following User Says Thank You to patt For This Useful Post:

    jimbadge (2011-03-12)

  4. #3
    Star Lounger tgw7078's Avatar
    Join Date
    Jul 2010
    Location
    Seattle, WA., USA
    Posts
    90
    Thanks
    1
    Thanked 12 Times in 12 Posts
    To add some to Patt's reply, see the following Microsoft KB article. Ignore the "ACC2000" in the title, as this applies to all versions of Access:

    ACC2000: Error When Running Crosstab Query with a Parameter
    http://support.microsoft.com/?id=209778
    Tom Wickerath
    Microsoft Access MVP
    4/1/2006 - 3/31/2012

  5. The Following User Says Thank You to tgw7078 For This Useful Post:

    jimbadge (2011-03-12)

  6. #4
    New Lounger
    Join Date
    Oct 2009
    Posts
    13
    Thanks
    3
    Thanked 0 Times in 0 Posts
    I hasd seen a feference to defining a parameter in the query but did not know how. This got my qiery working.
    Thanks to both of you!
    Jim Badgett

Posting Permissions

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