SELECT File.FileName AS File, Count(File.FileName) AS [Number of Error 500 Hits] FROM (Hit INNER JOIN File ON Hit.FileID = File.ID) INNER JOIN xDateFilter ON Hit.DateTimeID = xDateFilter.ID WHERE (((Hit.Status)=500)) GROUP BY File.FileName ORDER BY Count(File.FileName) DESC;