多条件DSum函数使用的例子
方法一:
Private Sub 数量_AfterUpdate()
Me.[数量相加] = DSum("数量", "PO", "订单号='" & [订单号] & "'and [物料号] = '" & [物料号] & "' and [订单日期]<= #" & [订单日期] & "#")
End Sub
方法二:
Select PO.订单号, PO.物料号, PO.数量 AS 数量, PO.订单日期, DSum("数量","PO","订单号='" & [订单号] & "'and [物料号] = '" & [物料号] & "' and [订单日期]<= #" & [订单日期] & "#") AS 数量相加
FROM PO;
供参考
附 件:
点击下载此附件