R
Ripper
I have a table, tblCBAs, which contains results from a curriculum based
assessment given at the end of each grading period.
I joined that with tblStudents which holds all the information about each
kiddo.
Finally, I want to obtain and display some information from the table.
I created a query to average the grade for each teacher. No problem.
I also created a query to count the ethnic code for each student by teacher
and give me an average for that. No problem
I just can't figure out how to get the whole teacher average and the 4
ethnic code averages all into the same report.
eg.
Teacher Whole% AfAmer% Asian% Hispanic% etc
Smith 84% 81% 88% 80%
Any tips?
assessment given at the end of each grading period.
I joined that with tblStudents which holds all the information about each
kiddo.
Finally, I want to obtain and display some information from the table.
I created a query to average the grade for each teacher. No problem.
I also created a query to count the ethnic code for each student by teacher
and give me an average for that. No problem
I just can't figure out how to get the whole teacher average and the 4
ethnic code averages all into the same report.
eg.
Teacher Whole% AfAmer% Asian% Hispanic% etc
Smith 84% 81% 88% 80%
Any tips?