Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Joliette, Quebec, Canada
    Posts
    290
    Thanks
    9
    Thanked 0 Times in 0 Posts

    Crosstabs quandry (2000)

    While i have no problem running a select query using criteria ( combobox1) from a form, I cannot seem to make it work in a crosstabs query.
    Nor can i use the generate a crosstabs query bases on query that has a criteria value of Forms![SelectionForm]![Selectionvariable] in it
    can any one steer me in the right direction
    <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    Richard

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

    Re: Crosstabs quandry (2000)

    You must declare the parameter explicitly, both in the underlying query and in the crosstab query.
    Select Query | Parameters...
    In the first column, enter Forms![SelectionForm]![Selectionvariable], amd in the second column, select the appropriate data type. Then click OK.

    If you still have problems, please provide some more details about the query/queries you are trying to design.

Posting Permissions

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