G
Guest
I created a custom form to supply parameters to a report based upon a
crosstab query. The form seems to operate fine, except it only will accept a
single set of values, as if it is storing the values it wants to respond
to...!
The parameter form asks for [Summary Date] and [Summary Iteration]. The
underlying crosstab query has rows where [Summary Date] = 5/12/05, 5/17/05,
5/20/05 and [Summary Iteration] = 1,2.
Using my custom parameter form (in the Open Event of the report), everything
works fine when I enter 5/20/05 for [Summary Date] and 1 for [Summary
Iteration]. However when I enter any other valid combination of values for
[Summary Date] and [Summary Iteration] I get the error message "The Microsoft
Jet database engine does not recognize “ as a valid field name or expression."
When I run the crosstab query from the Database Window, I can successfully
enter any valid combination of values to the 'Enter Parameter Value' pop-ups
and the correct Datasheet view comes up...
Do you know how to correct the error in my custom parameter form?
Thanks!
crosstab query. The form seems to operate fine, except it only will accept a
single set of values, as if it is storing the values it wants to respond
to...!
The parameter form asks for [Summary Date] and [Summary Iteration]. The
underlying crosstab query has rows where [Summary Date] = 5/12/05, 5/17/05,
5/20/05 and [Summary Iteration] = 1,2.
Using my custom parameter form (in the Open Event of the report), everything
works fine when I enter 5/20/05 for [Summary Date] and 1 for [Summary
Iteration]. However when I enter any other valid combination of values for
[Summary Date] and [Summary Iteration] I get the error message "The Microsoft
Jet database engine does not recognize “ as a valid field name or expression."
When I run the crosstab query from the Database Window, I can successfully
enter any valid combination of values to the 'Enter Parameter Value' pop-ups
and the correct Datasheet view comes up...
Do you know how to correct the error in my custom parameter form?
Thanks!