sum() in SQL Builder

[Ruslan Zasukhin]

On 24/11/07 12:54 PM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,

> 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.

Well, may be it is bug.
Please report it into Mantis.

For now you can copy query to SQL Editor and add it manually
 
> 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?



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]