Mark,

This may be a dumb question but.... how do I do that in the View Designer? The SQL is READONLY and I can't see anyway of doing that with the tabbed designer.

Thanks

Pete


>Try Un-Nesting the joins:

>
>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?
>
>No.