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?
(On an infant's shirt): Already smarter than Bush