Hi Scott, I have attached a pdf file with my query so that you are able to see the screen dumps.
For the first issue, Are you using the AVG function or are you using (a1+a2+a3)/3. If the latter you can use a DCount to count the number of non zero Assignments instead of hard coding the divisor.
For the second issue, can you show me the SQL for query?
Hope this helps,
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA