Multi-Average Query

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?
 
R

Ripper

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top