查询余额时出错

Question

我有一个现金表，字段:doc_num，叙述，日期，债权人，债务人现在我想显示每一行的余额sum(债权人-债务人)。同时显示之前的余额像这样:

--------------------------------------------------------------------------------------
doc_num-------date----------narration------------credit-------debtor---balance
--------------------------------------------------------------------------------------
                         previous balance                                 2000    
 1       2014/06/10        remit             5000          0              5000
 2       2014/06/12        bar                  0          2000           3000
 3       2014/06/15        remit             1000          0              4000

这是我的查询:

SELECT  ''                  AS docnum,
        ''                  AS c_date,
        'previous balance'  AS narration,
        " "                 AS creditor,
        " "                 AS debtor,
        Sum(creditor-debtor),
        "c_date< ' " &  2014/06/10  & "'" AS Balance 
FROM    Cash 
UNION 
SELECT  doc_num,
        c_date,
        narration,
        creditor,
        debtor,
        Sum(creditor-debtor),
        "doc_num<=" & doc_num AS Balance 
FROM    Cash
WHERE   (((Cash.c_date) Between ("2014/06/10") And ("2014/06/15")))
ORDER BY docnum;

i面对这个错误:您试图执行不包含指定表达式"doc_num"作为聚合的一部分的查询我使用这个查询访问(mdb)什么是正确的查询?由于

Answer 1

也许这个"one_answers"让我有点迷惑。

SELECT  ''                  AS docnum,
        ''                  AS c_date,
        'previous balance'  AS narration,
        " "                 AS creditor,
        " "                 AS debtor,
        Sum(creditor-debtor),
        "c_date< ' " &  2014/06/10  & "'" AS Balance 
FROM    Cash 
Group by '','','previous balance', " ", " ", "c_date< ' " &  2014/06/10  & "'"
UNION 
SELECT  doc_num,
        c_date,
        narration,
        creditor,
        debtor,
        Sum(creditor-debtor),
        "doc_num<=" & doc_num AS Balance 
FROM    Cash
WHERE   (((Cash.c_date) Between ("2014/06/10") And ("2014/06/15")))
GROUP BY doc_num,
        c_date,
        narration,
        creditor,
        debtor,
        "doc_num<=" & doc_num 
ORDER BY docnum;