H
Hong
Hello.
I have a crosstab query with parameter, when I run the query, the pop up
window by the access (not the parameter form I created),
Forms!ReportRange!Starting date, and so on...
I enter "starting date", "Ending date" and "programme" in th pop up window,
it works very well.
But when I open the parameter form: ReportRange. enter the same information
in the form. then click ok, to run the query, but it doens't work, there is
no data showing.
What did I do wrong, I believe the query is right, Is the parameter form
doesn't provide the range into the query, or the query didn't get the
information from the form?
Thank you!
I have a crosstab query with parameter, when I run the query, the pop up
window by the access (not the parameter form I created),
Forms!ReportRange!Starting date, and so on...
I enter "starting date", "Ending date" and "programme" in th pop up window,
it works very well.
But when I open the parameter form: ReportRange. enter the same information
in the form. then click ok, to run the query, but it doens't work, there is
no data showing.
What did I do wrong, I believe the query is right, Is the parameter form
doesn't provide the range into the query, or the query didn't get the
information from the form?
Thank you!