You can still drag your mouse over the code and hit Control-C to copy it. Then open a PRG and Control-V to paste it.

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