关于“MSSQL语句”转换成“Access语句”的问题
select 时间,sum(case when 收支= "收入 " then 钱字段 else 0 end) as "总收入 ",
sum(case when 收支= "支出 " then 钱字段 else 0 end) as "总支出 " from 收支表
where 时间 between '2007-1-1 ' and '2007-1-2 ' group by 时间
------------------------------------------------
以上怎么转换成Access语句?
[解决办法]
SELECT [时间], sum(IIf([收支]= "收入 ",[钱字段],0)) AS 总收入, sum(IIf([收支]= "支出 ",[钱字段],0)) AS 总支出
FROM 收支表
WHERE 时间 between #2007-1-1# and #2007-1-2#
GROUP BY [时间]
