>Either I missed it or you haven't said what Pat_last represents, but it seems to me that you could either use MAX() or MIN() on the field to narrow it down to a particular record, or add it to the GROUP BY clause.
>
Hi Tamar:
Pat_last is the lastname of the patient.
>Tamar
- Ravi
True greatness consists in being great in little things.
- Charles Simmons