关于查询求助

“是”就是-1求和当然是负数，

乘-1就可为正，

SELECT Sum(表1.性别)*-1 AS 性别之计数, Sum(表1.党员)*-1 AS 党员之计数, Count(表1.学习) AS 学习之计数
FROM 表1
WHERE (((表1.日期) Between [输入日期1] And [日期2]) AND ((Sum([表1].[性别]))=Yes) AND ((Sum([表1].[党员]))=Yes));