Windows XP 
Access 2007
Good morning, my first Access post, so I'm a bit new at this.
I'm using a database to keep track of faculty assessments and ratings. The table has a listing for faculty name, academic year, course, questions 1-9 (scorred numerically from 1-5) and a comment field.
I've built 2 queries, one to drive the majority of the reporting (qryFacAssessment), another to simply to calculate the averages for all 9 questions (qryFacAssessMean).
The report works well and takes the numerical information of each faculty member and compares it to the average. What I would like to do is further break this down by course. I can sort the qryFacAssessMean by course, and the query gives me the correct averages per question per course. My problem is that I can't seem to figure out how to get that specific information over to the report, and then calculate a the average for the total of all courses. I have tried using DAvg, and only get an error message.
Any help in the right direction would be most helpful.
Many thanks in advance.
Zipdoc
Reply With Quote
