I am trying to create a report that gives a scoring system.

I have created a database of questions, each with six scoring levels(drop down within the database). I would like to create a report with the user information, and number of questions scored 1, scored 2, scored 3, 4, 5 and six, then a total questions with percents for each level.

In an attempt to do this I have created a query listing the question marked 1, then another marked 2, and so on.

I can use the wizard and create a report for each query, giving the total for that one, but I want to do this for the group as a whole.

thanks

unfortunately, this typpe of explanation is very difficult to follow because no specifics have been on a "detailed" level. uploading your database, and possibly some accompanying JPEGS would better help get you some help with this i would guess.

thanks for your quick reply

The database has 3 tables, student, question and questionProgress. questionProgress has a drop down, with marks 1 through to 6. I want to create a report that tells me how many questions where marked 1, 2 and so on.

I there a way of creating a temp variable within the report the stores a count of the progress marked 1, 2 and so on. I am really not sure how to go about it, so apologize for any vagueness.