Multi-Average Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Worked like a charm. Thanks.

I guess I need to brush up on query types. Do you have a resource to help
the query novice?
 
Back
Top