Filtering by a control causes error in crostab query

[SunWuKung]

I have several queries embedded in each other and at one point one of them is filtered by a control on a form. The final query runs nicely if it is a simple select query but gives me an error message if I turn it into a crosstab query saying that the [control name] cannot be recognised as a valid field name or expression, although the contol is never used as one and anyway is several queries earlier. In the final query there are only three very ordinary columns that I can't find a way to turn into a crosstab query.

Could you tell me what might be causing the problem?

Thanks in advance.
SWK

[This message has been edited by SunWuKung (edited 08-13-2001).]

 

[SunWuKung]

Thanks Pat, it seems that you are right. If I only change the condition to an exact value instead of a control name the crosstab works. But than how could I filter the rows on which I want to run my crosstab query based on a control?
Is it realy impossible? Should I write code for that? What would you suggest to get around this problem.

Thanks.

SWK.

 

[SunWuKung]

Thanks Pat, that was the solution.