Crosstab

[gdanalakshmi]

I have a parameter query (BaseQry) that takes the parameters from the Form.

THen I built a crosstab query using BaseQry. But when I try to run the crosstab, i get the following error -

Microsoft JEt Engine doesnot recognise [Forms]![ReportMenu]![StartDate] as a valid expression.


But if i hardcode the dates in the BaseQry and then run the crosstab query, i get the expected result.

How do i dynamically specify the parameter for the BAseQry without getting the error

 

[Sohaila Taravati]

Try making another query out of your crosstab and the baseQry and take your critaria out of your baseQry and put it in your new one. That should do the trick

 

[Rich]

You have to define the Parameters for the crosstab
ie. Forms!MyForm!MyField Date/Time

 

[gdanalakshmi]

If I move the criteria to the crosstab query then my query will be lot slower since it is not limited by the criteria.

 

[gdanalakshmi]

I tried moving the parameter to the crosstab, but still i am getting the same Jet engine error??

 

[gdanalakshmi]

Thanks for your reply. I just figured it out what Rich suggested.

It is working when I specify the type of the parameters in the crosstab.

 

[rich.barry]

Brilliant.
I just posted the same problem, but then thought I'd better read the other thread titled "CrossTab".
Wadda you know...quick fix within. (and a fast Edit..Delete so as not to appear an idiot).

For any one with the knowledge, when should one declare parameters for a query?
Does it improve the speed or anything else by doing so?

Richard