Ok, I have a grades database with a main table that contains a list of all the students in our school. I have also made a query that contains all of the same information as the table. The fields of concern are:
StudentName
Classroom
Exam #1
Exam #2
Exam #3
Exam #4
Exam #5
For the sake of brevity, I am using "Exam" in place of the real exam name. There are actually 15 exams but for this question 5 will do.
What I am trying to do is create a form with a classroom combobox and an exam combobox that will allow the user to generate a grades report for all the students in a particular class for a particular exam.
I am moderately familiar with access and vba but I have never attempted to do something like this. Don't laugh if this is simple.
So far I have created the form with the necessary fields but I am at a loss as to how to create the report so that when I select a classroom and an exam and click a button to view the report I only see the students in that class in one column and there test score for the selected exam in the other column of the report detail.
I can easily write the code to filter the rows to only display the students in the selected classroom but I have no clue what code I need to only display the column that contains the test scores for the selected test.
Any and all help would be greatly appreciated.
Thanks, Sean