sum() in SQL Builder

[Barry G. Sumpter]

Select EmpName, EmpDept, Sum(EmpHoursWorked) 
>From tblEmp 
Group by EmpName, EmpDept


-----Original Message-----
From: valentina-studio-bounces at lists.macserve.net
[mailto:valentina-studio-bounces at lists.macserve.net] On Behalf Of Barry G.
Sumpter
Sent: Saturday, 24 November 2007 9:40 PM
To: valentina-studio at lists.macserve.net
Subject: sum() in SQL Builder

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



_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio