I have a crosstab query that shows all the scores of all the activities of
all the students in all courses, with the students being in the rows and the
activities being in the columns and the scores being in the intersections of
the rows and columns.
I also have a report based on this query that, depending on the activity
names, will dynamically insert the field names into the column labels, so
that I don't have to make a new report every time I get a new course or
change activity names, etc.
Problem: it displays ALL the courses together. Some courses have different
activities, so blank columns appear for some of the students and other
columns are blank for other students. I want only one course to appear. So
I tried to apply a criteria in the query, and that worked in the query. the
query now shows only one course at a time. But adding the criteria in the
query apparently crashed my report. Now I'm getting, "Run-time error '3061'
too few parameters. Expected 0."
The recordset inside the report is very simple:
StrSQL = "SELECT * FROM qryTableOfGrades;"
I don't understand how I'm asking for the wrong number of parameters since
'*' means all. This worked before I added the WHERE condition to the query.
Now it won't.
Any help will be appreciated. Thanks.
Richard Hollenbeck