W
Wim
Hi all,
I have an examination result report based on a crosstab
query (E2), which itself is based upon a parameter select
query (E1). I want to be able to limit the results to
e.g. the spring classes in 2003.
So I have in the criterion row in E1 : Like [give the
course code e.g. 04*]. In the query parameters window I
ask in the parameter column : [give the course code e.g.
04*] and in the data type column : text.
When I type 03* I get the results of all the exams for
2003; when I type 03S* I get all the results for he spring
classes; when I type 03F* I get all the fall results, so
this works fine. When I run E2 : this works fine as well.
But when I want to print the report based upon E2 !
If I give for the parameter 03* : I get the results of
all the exams for 2003. If, however, I type 03S* I get an
error message : The Microsoft Jet-databse-engine can't
recognize as a valid fieldname or expression. The Help
button refers to error 3070. In the query parameter
window in E2 I have the same parameter + data type as in
E1.
The coursecode field is a row heading in my query. So I
can't describe columheading properties ??
But what I don't understad is that 03* works but 03s* not !
I posted this question to the query group, I got an answer
suggesting a posting to this group. Which I did after a
Google search for possible answers.
Thanks for your answer,
Wim
I have an examination result report based on a crosstab
query (E2), which itself is based upon a parameter select
query (E1). I want to be able to limit the results to
e.g. the spring classes in 2003.
So I have in the criterion row in E1 : Like [give the
course code e.g. 04*]. In the query parameters window I
ask in the parameter column : [give the course code e.g.
04*] and in the data type column : text.
When I type 03* I get the results of all the exams for
2003; when I type 03S* I get all the results for he spring
classes; when I type 03F* I get all the fall results, so
this works fine. When I run E2 : this works fine as well.
But when I want to print the report based upon E2 !
If I give for the parameter 03* : I get the results of
all the exams for 2003. If, however, I type 03S* I get an
error message : The Microsoft Jet-databse-engine can't
recognize as a valid fieldname or expression. The Help
button refers to error 3070. In the query parameter
window in E2 I have the same parameter + data type as in
E1.
The coursecode field is a row heading in my query. So I
can't describe columheading properties ??
But what I don't understad is that 03* works but 03s* not !
I posted this question to the query group, I got an answer
suggesting a posting to this group. Which I did after a
Google search for possible answers.
Thanks for your answer,
Wim