在输出中,当TOTAL_AMT很小时,比如0.1,TOTAL_AMT1只会返回0.0。为什么会这样呢?Extract (YEAR From CREATED_AT) AS YEAR_NO,CURRENCY_ID
, Cast((Sum(AMOUNT )/100) AS DECIMAL(6,1)) AS TOTAL_AM
我正在尝试使用ms-access查询来计算帐户对帐单的运行总和,但是当有重复的日期时,我遇到了问题。在日期更改之前,总和是不会更改的 这是结果的img链接: https://i.stack.imgur.com/eUfa2.png 下面是查询: SELECT Trans.TransDate, Trans.Cr, Trans.Dr, (SELECT SUM(t.[Dr]-t.[Cr]) FROM Trans t WHERE t.[TransDate]<= Trans.[TransDate] AND t.Account = Trans.Account) AS Balance
FROM Tra