I can get this statement to work in SQL Server but will not work in Access:
SELECT AVG(a.Answer) AS avgscore, t.Category_name,
p.Project_id
FROM TEAM_MEMBERS tm INNER JOIN
PROJECT p ON tm.Project_id = p.Project_id INNER JOIN
ANSWER a INNER JOIN
PAGE t ON a.Page_id = t.Page_id ON
tm.Member_id = a.Member_id
GROUP BY p.Project_id, t.Category_name
SELECT AVG(a.Answer) AS avgscore, t.Category_name,
p.Project_id
FROM TEAM_MEMBERS tm INNER JOIN
PROJECT p ON tm.Project_id = p.Project_id INNER JOIN
ANSWER a INNER JOIN
PAGE t ON a.Page_id = t.Page_id ON
tm.Member_id = a.Member_id
GROUP BY p.Project_id, t.Category_name