SELECT [1].[no], [1].qty, DSum("qty","1","no<=" & [no]) AS [total-qty]
FROM 1;
得到的结果却是:
no qty totoalqty
10-001 20 90
10-002 30 90
10-004 30 90
10-010 10 90
请帮忙看一下我是哪里错了呀.谢谢各位!作者: djt 时间: 2007-6-27 19:02
SELECT [t1].[no], [t1].qty, (select sum(t2.Qty) from [1] as t2 where [t2.no]<=[t1.no]) AS [total-qty]
FROM 1 as t1作者: dorislh 时间: 2007-6-27 19:31
谢谢djt,
可是我怎么一运行这个语句,系统就出现错,必须关闭ACCESS,不能运行哦.
作者: djt 时间: 2007-6-27 19:35
这个就没法帮助了作者: djt 时间: 2007-6-27 19:38
select [t1.No],t1.Qty,sum(t2.Qty)
from [1] as t1 inner join [1] as t2
on [t1.no]>=[t2.no]
group by t1.no,t1.Qty作者: dorislh 时间: 2007-6-27 19:53
谢谢djt: