I need to sum the field *COST* in this query where data in *STATUS* is
equal to "HELD" and "OPEN", so I will have 2 totals passed below and do
not know where to begin .


All information is in 1 table.


Original query

select distinct(Company_name), account, City, State from table where
number = 100


I need to be able to pull the $$ amount totals by company name for
status equal to HELD and OPEN .




 Company A      OPEN               HELD


 1233            100.00                50.00



Any suggestion would be appreciated.




Larry Sandwick



Larry Sandwick

Sarreid, Ltd.

Network/System Administrator

phone: (252) 291-1414 x223

fax      : (252) 237-1592


Reply via email to