Ray:
Maybe the context in which I’m using the AVG() function is not the appropriate one, but I’m getting an error message saying: Unknown column ‘cwAverage’ in field list.
This is the SELECT I’m using:
SELECT oxadmain.name , oxadmain.year , oxadmain.photoID , oxadmain.thumbs , stuperfdaily.ID , stuperfdaily.stuid , stuperfdaily.date , stuperfdaily.subject , stuperfdaily.teacher , stuperfdaily.cw , stuperfdaily.hw , stuperfdaily.con , stuperfdaily.par , stuperfdaily.att, AVG(cw) as cwAverage, AVG(hw) as hwAverage, AVG(con) as conAverage, AVG(par) as parAverage, AVG(att) as attAverage, ROUND((cwAverage+hwAverage+conAverage+parAverage+attAverage)/5, 2) AS avg FROM stuperfdaily INNER JOIN oxadmain ON stuperfdaily.stuid=oxadmain.stuid GROUP BY stuperfdaily.stuid
ORDER BY oxadmain.stuid ASC
Any suggestions?
Just in case, attached please find a copy of the page in question.
Thank you for your attention