That's the one!

Thanks very much for your (all) assistance.

Ronald

Thanks for your response...

I have now altered the code to:

Select users.userID, Username, avg(average1dart), count(*) as Total, RANK() over (order by count(*) DESC, AVG(average1dart) DESC) as Rank

from stats INNER JOIN Users...