Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    CROSSTAB PARAMETER QUERY FAILS (2000)

    I have a created a cross tab query and it works fine. In the design view, I am able to enter Criteria on a Row Heading field (Site). But when I enter a parameter query in Site - Criteria to prompt users for the site name (Like [Enter first letters of the site] & *), the cross tab fails. (I've read some replies by Charlotte and she confirms that parameters tend to choke in a cross tab.)

    I can instruct the end-users to edit the query to get the results they want, but I would like to automate if possible. Any work arounds or suggestions? THANK YOU.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: CROSSTAB PARAMETER QUERY FAILS (2000)

    Did you add the criteria to the query's parameters?
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Los Angeles
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: CROSSTAB PARAMETER QUERY FAILS (2000)

    That did it! Thanks!

Posting Permissions

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