royteusink

This works good, thanks for the replies

Hi all,I've got a small Access SQL question. I need to order my output by the AVG(SUM of multiple fields)Something like this, but this doesn't work: SELECT * FROM Reportings WHERE Year = '2006' ORDER BY AVG(WorkspecPoint+ToolboxPoint+NearmissPoint) DESC Does anyone of you guys have any idea how to solve this? Much Grasias,Roy Teusink