By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,133 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

Filtering a dynamic report based on crosstab query

P: n/a
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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.