Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    23

    Question Unanswered: cross tab parameter

    Hi,

    I been trying to put a parameter for my cross tab querie and it keep coming up with the same error message. Example, Fields are: Result(column heading) Date(row heading), Result(Count)

    Now, I want to create a parameter that ask the user to input the month I want to get the count for. I did this is the regular querie but can't find a way to do it in cross tab using parameter. I don't wanna use criteria because user are not going to have access to the design part of the cross tab querie. Is there a way to create a parameter for a cross tab like you would for a regular querie? Any help is appreciated. Thanks

  2. #2
    Join Date
    May 2002
    Location
    London
    Posts
    3

    Wink Desperate

    I am desperate to find the answer to your question. I was trying to implement a date range into my crosstab query.

    Do you get that message about MS Jet engine not recognising etc....??

  3. #3
    Join Date
    May 2002
    Location
    London
    Posts
    3

    Talking Gotit

    Hey, I've found how to do it.

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q209778

    this link explains all.

    Just to simplify though: enter your parameter example [enter branch] in the criteria section of your crosstab query and then go to the menu bar, Query - Parameter and enter [enter branch] with the data type.

    That should sort it.

Posting Permissions

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