>No, don't change the GROUP BY clauses...you need to determine if the fields that aren't in the group by clause are returning the correct information (for example, other fields could return correct information if they contain repeating information).
>
>Does that make sense?
>
Steve:

Here's what I tried. I added the two remaining fields to the Group By Clause and the error message no longer appeared. I had left another Group bY Clasue as is - and that code returned an error message when it ran.

But what you are saying is, not to add anymore fields to the group by clause? The results returned by the other two fields by teh original Group By Clause were correct i.e., contained the lastname and the name of the doctor. And do I take it, that I simply setengine to 70 here and turn it back on to 80 as soon as the select statement is done?