SHAPE {SELECT * FROM [Authenticated Users]} APPEND ( { SELECT Visitor.UserName, File.FileName, Count(Hit.ID) AS [Number of Hits], Round(Sum([Hit].[BytesOut])/1024) AS [Data Transferred(Kb)] FROM (Hit INNER JOIN ((Visit INNER JOIN Visitor ON Visit.VisitorID = Visitor.ID) INNER JOIN (xDateFilter INNER JOIN Date_Time ON xDateFilter.ID = Date_Time.ID) ON Visit.BegDateTimeID = Date_Time.ID) ON Hit.VisitID = Visit.ID) INNER JOIN File ON Hit.FileID = File.ID GROUP BY Visitor.UserName, File.FileName HAVING (((Visitor.UserName) Is Not Null)) ORDER BY Visitor.UserName, Count(Hit.ID) DESC; } RELATE UserName TO UserName )