I created the following view and the ORDER BY settings don't seem to be working... (it was originally created with the Wizard then modified)....

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;
INNER JOIN timepro!code ;
ON Log.codeid = Code.codeid ;
ON Employee.employeeid = Log.employeeid;
ORDER BY Log.firmid, Employee.lastname, Employee.firstname,;
Code.codenum, Code.codetype


When I BROWSE the view, the only part I can find in order is the CODENUM and CODETYPE fields.

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?

Thanks