数据表
收入表
支出表
查询
SELECT DISTINCTROW Format$([收入].[ID],'yyyy\年mm\月') AS [ID 按月], Sum() AS [工资收入之合计], Sum() AS [奖金收入之合计], Sum() AS [其他收入之合计]
FROM 收入
GROUP BY Format$([收入].[ID],'yyyy\年mm\月'), Year([收入].[ID])*12+DatePart('m',[收入].[ID])-1;
SELECT DISTINCTROW Format$([支出].[ID],'yyyy\年mm\月') AS [ID 按月], Sum() AS [早饭之合计], Sum() AS [零食之合计], Sum() AS [中饭之合计], Sum() AS [饮品之合计], Sum() AS [晚饭之合计], Sum() AS [出行之合计], Sum() AS [购物之合计], Sum() AS [玩之合计]
FROM 支出
GROUP BY Format$([支出].[ID],'yyyy\年mm\月'), Year([支出].[ID])*12+DatePart('m',[支出].[ID])-1;
按月度总收入合计
SELECT 收入月度查询.[ID 按月], 收入月度查询.[工资收入之合计]+收入月度查询.[奖金收入之合计]+收入月度查询.[其他收入之合计] AS 总收入
FROM 收入月度查询;
SELECT 支出月度查询.[ID 按月], 支出月度查询.[早饭之合计]+支出
收支汇总合计 来自淘豆网www.taodocs.com转载请标明出处.