The rules are that either a column is an aggregate column, meaning it is involved in a Sum, Max, Min...etc, or it is listed in the Group By clause.

Jay has given you several options. I personally prefer the method of Maxing the columns you don't care about (ex. Select Max(LName)).

PF

>All I am trying to do is run a query that group by a particular field with this new sintax?
>
>Any suggestions?