SHAPE {select * from [Top Accessed Pages]} APPEND ( { SELECT File.FileName, Visit.UserName, Count(File.FileName) AS [Page Views], Round(Sum(Hit.BytesOut)/1024) AS [Data Transferred(Kb)] FROM (((Hit INNER JOIN File ON Hit.FileID = File.ID) INNER JOIN ExtPages ON File.Extension = ExtPages.Extension) INNER JOIN xDateFilter ON Hit.DateTimeID = xDateFilter.ID) INNER JOIN Visit ON Hit.VisitID = Visit.ID GROUP BY File.FileName, Visit.UserName ORDER BY Count(File.FileName) DESC } RELATE FileName TO FileName )