Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Basis for Crosstab (xp/2k)

    I have a form that provides the dates that are the parameters for a totals query. This works correctly. I then based a crosstab query on that totals query. IF I have the form open, and try to open the crosstab query direcly, it tells me that it does not recognize the parameters. What is the proper way to do this?
    Thanks

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

    Re: Basis for Crosstab (xp/2k)

    Have you declared the parameters explicitly?
    - Open the totals query in design view.
    - Select Query | Parameters...
    - Enter the parameters exactly as they are used in the Criteria of the query, and specify their data types (Date/Time probably)
    - Click OK.
    - Save the query.
    If that is not sufficient, also declare the parameters in the crosstab query.

Posting Permissions

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