crosstab query parameter

[chriske911]

I am using a XT query based on yet another "group by" query
if I set a parameter in the "group by" query the XT query fails
it does this telling me the "parametername" is not a valid field or
expression

I hoped it would present me with a prompt as it does with the "group
by" query
how can I still set a parameter for the underlying query instead of
working with a fixed value for that parameter?

thnx

 

[Allen Browne]

You can use a parameter *in* a crosstab query by declaring it. I doubt you
can use a parameter in the underlying query like that.

You could try opening a form with a text box where the lower level query can
read the value from, e.g.:
[Forms].[Form1].[Text0]
and see if the Expression Service will resolve this for you.

In a crosstab, you can get away without having to declare your parameter
provided you set the Column Headings property of the crosstab query. I don't
know if that will have any bearing on your lower level query, but I doubt
that would work.