第一次的问题，查询中累计递增

比如计算销售金额的递增累计可以：

SELECT *, DSum("销售金额","KPI","部门='" & [部门] & "' and ID<=" & [ID]) AS 累计销售金额
FROM KPI;

或者：

SELECT a.*, (select b.销售金额  from KPI as b where b.部门=a.部门 and b.ID<=a.ID) AS 累计销售金额
FROM KPI as a;