Sum Function in a Query

[alexkeel79]

I'm am trying to run the following query but I am getting an error:

SELECT TRR.empBUnit, TRR.empDivision, TRR.empDirector, TRR.empGroup,
-Sum(TRR.Status='Completed') AS Completed,
-Sum(TRR.Status='In Progress') AS InProgress
FROM TenRulesSecAdminRAW TRR
GROUP BY TRR.empBUnit, TRR.empDivision, TRR.empDirector, TRR.empGroup, TRR.Statues;

This is the error that I get:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '='.

I have run this query in an Access

 

[JohnDTampaBay]

How does this work for you?

SELECT TRR.empBUnit, TRR.empDivision,
    TRR.empDirector, TRR.empGroup,
    -Sum(CASE WHEN TRR.Status='Completed'
              THEN 1 ELSE 0 END
     ) AS Completed, 
    -Sum(CASE WHEN TRR.Status='In Progress'
              THEN 1 ELSE 0 END
     ) AS InProgress
FROM TenRulesSecAdminRAW TRR
GROUP BY TRR.empBUnit, TRR.empDivision,
  TRR.empDirector, TRR.empGroup;

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)