ms-access - Access 中的运行总计问题
问题描述
我正在尝试将运行总计添加到访问查询中,在观看有关如何执行此操作的视频后,我想出了以下内容;
SELECT Analyst, [Grant ID], [Fiscal Year], Available, Recovered, Bal,
(SELECT SUM(Bal) FROM QueryTest WHERE C.[Fiscal Year] >= [Fiscal Year] and C.[Grant ID] = [Grant ID]) as
RunningBalance
From QueryTest AS C
ORDER BY Analyst, [Grant ID];
但是当我运行它时,它表明
数据库引擎无法将 C.[会计年度] 识别为有效字段,这表明使用别名有问题,但我无法弄清楚它是什么。
任何帮助表示赞赏。
解决方案
在内部查询而不是外部查询中尝试 C 别名。
SELECT Analyst, [Grant ID], [Fiscal Year], Available, Recovered, Bal,
(SELECT SUM(C.Bal) FROM QueryTest AS C
WHERE C.[Fiscal Year] >= QueryTest.[Fiscal Year]
AND C.[Grant ID] = QueryTest.[Grant ID]) as RunningBalance
FROM QueryTest
ORDER BY Analyst, [Grant ID];
一个更简单的替代方法是构建报告并使用文本框 RunningSum 属性。