Select Sum(..) etc

[Barney]

Hi,

Is it not allowed to have a WHERE clause in a Select statement that includes
Sum(...) ?

This statement won't work for me ?

P2cur = window1.db.sqlSelect("select

SUM(Cost),SUM(OBV),SUM(SalePrice),Sum(DeprRec),Sum(capgain) from reportData

where description <> 'Sub Summary' ")

I am trying to get a sum of everything in the table except for the records
which have "Sub Summary" written into their description field.

Many thanks

Barney