[求助]怎样在一个表里求出上月结存？

cdwlove

怎样在一个基础查询表里求出上月结存？谢谢~~

一点通

SELECT IA_Summary.iMonth AS 会计期间, nz(DSum("[iMoney]","IA_Summary","[iMonth]=" & [会计期间]-1),0) AS 上月结存, Sum(IA_Summary.iIMoney) AS 本月收入金额, Sum(IA_Summary.iOMoney) AS 本月发出金额, Sum(IA_Summary.iMoney) AS 本月结存金额
FROM IA_Summary INNER JOIN IA_Summary AS IA_Summary_1 ON IA_Summary.AutoID = IA_Summary_1.AutoID
GROUP BY IA_Summary.iMonth;

zczc123

学习下

goto2008

学习[:24]

6100535

看看,学一学

a30088

ding

a30088

看看,学一学