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?

Thank you for your time Mark. It is appreciated.