如何将dlast更换成子查询

Henry D. Sy

SELECT 按业务员查利润.年月, 按业务员查利润.姓名, CCur(Nz(DLast("[差额]","业绩差额","年月<'" & [年月] & "'and 姓名='" & [姓名] & "'"),0)) AS 期初, 按业务员查利润.利润, IIf(([期初]+[利润]-2400)<0,[期初]+[利润]-2400,0) AS 差额, [期初]+[利润]-2400 AS 计奖利润, [期初]+ [利润] AS 比率标准, [计奖利润]*bl([比率标准]) AS 奖金
FROM 按业务员查利润;

Henry D. Sy

以下是引用andymark在2007-6-8 21:15:00的发言：


看到长的代码就晕,把例子传上来

例子在这，谢谢你先！！

http://www.office-cn.net/forum.php?mod=viewthread&tid=54683

andymark

看到长的代码就晕,把例子传上来