select 科室
sun(iif(职称='技术员',1,0)
....
from bbc group by 科室

樓主自已實驗一下不就知道了......

可以。
select 科室,;
sum(iif(职称='技术员',1,0) as 技术员,;
....;
from bbc group by 科室

因通不过，请教了。命令如下(我是照抄张洪举权威批南书上的内容)
SELECT kx SUM(IIF(职称="助工",1,0)) AS 助工, ;SUM(IIF(职称="高工",1,0)) AS 高工, ;SUM(IIF(政治="团员",1,0)) AS 团员 ,;SUM(IIF(政治="党员",1,0)) AS 党员 ;from ab GROUP kx
提示有不可识别的语句。
附上表

SELECT kx, SUM(IIF(职称="助工",1,0)) AS 助工, SUM(IIF(职称="高工",1,0)) AS 高工,SUM(IIF(政治="团员",1,0)) AS 团员 ,SUM(IIF(政治="党员",1,0)) AS 党员 from ab group by  kx
这里掉了一个，SELECT kx,