sum() in SQL Builder

[Barry G. Sumpter]

How do I use the sum() function in the SQL Buider?

I select a table 
then select which field
the select the Group By Icon
but the Sum() function is not in the drop down list for Group By Functions.

Any help would be greatly appreciated.


Also: 
Select EmpName, Sum(EmpHoursWorked) from tblEmp

Won't work on a v35.b7 db but it DOES work in v1.1 db
It seems you can't mix the non-grouped field with grouped fields
Anyone have any tips or tricks for this situation?

Thanks,
      Barry G. Sumpter