>Hi Mark:
>
>Here is the code in question.
>
>

SELECT Appointments.app_time, Appointments.app_date,;
>   Appointments.pat_last;
>  FROM appointments;
>  where appointments.app_date >= mquerydate .AND.;
>  appointments.app_date <= mquerydate + 8;
>  GROUP BY Appointments.app_time, Appointments.app_date;
>  ORDER BY Appointments.app_time, Appointments.app_date;
>  INTO CURSOR existingappoints nofilter

>
>And sice this code does not contain aggregate functions the GROUP BY clause should include Appointments.pat_last?
>
>What if there were 10 fields in teh select statement, has a Group By clause, and no aggregate functions. Should all the 10 fields be identified in the Group By clause, and in the order of how they should be grouped?
>

Henry,

The order of columns in GROUP BY clause has no effect on grouping result.