Hi,
I have a crosstab query based on a select query requiring parameters to be entered via a dialog form.
Everything works fine when the parameters are typed directly via a dialog box (select query and crosstab query run perfectly).
When using the form to enter the paramaters, only the select query runs correctly.
It seems that a crosstab query cannot simply work with parameters entered through a form.
Of course, I've declared all parameters in the crosstab query (again, when parameters are set directly, the Xtab query runs without problem).
So, can anyone confirm that there is a bug concerning this particular topic (running a crosstab query via criteria form) ? Or am I doing something wrong ?
Thanks in advance for any help (and please apologize my -well, not so good- English syntax !)
Tom
I have a crosstab query based on a select query requiring parameters to be entered via a dialog form.
Everything works fine when the parameters are typed directly via a dialog box (select query and crosstab query run perfectly).
When using the form to enter the paramaters, only the select query runs correctly.
It seems that a crosstab query cannot simply work with parameters entered through a form.
Of course, I've declared all parameters in the crosstab query (again, when parameters are set directly, the Xtab query runs without problem).
So, can anyone confirm that there is a bug concerning this particular topic (running a crosstab query via criteria form) ? Or am I doing something wrong ?
Thanks in advance for any help (and please apologize my -well, not so good- English syntax !)
Tom