SELECT Employee.employeeid, Employee.lastname, Employee.firstname, ; Log.employeeid, Log.firmid, Log.codeid, Log.logdate, Log.time, Log.rate, ; Code.codeid, Code.codenum, Code.codetype, Code.codedesc ; FROM timepro!employee ; INNER JOIN timepro!log ; ON Employee.employeeid = Log.employeeid ; INNER JOIN timepro!code ; ON Log.codeid = Code.codeid ; ORDER BY Log.firmid, Employee.lastname, Employee.firstname, ; Code.codenum, Code.codetype>Also... when you use a view on a REPORT and in the report you set up some data grouping, does that override the ORDER BY of the view?