多条件DSum函数使用的例子

 方法一:

Private Sub 数量_AfterUpdate()
Me.[数量相加] = DSum("数量", "PO", "订单号='" & [订单号] & "'and [物料号] = '" & [物料号] & "'  and  [订单日期]<= #" & [订单日期] & "#")

End Sub

 方法二:

Select PO.订单号, PO.物料号, PO.数量 AS 数量, PO.订单日期, DSum("数量","PO","订单号='" & [订单号] & "'and [物料号] = '" & [物料号] & "'  and  [订单日期]<= #" & [订单日期] & "#") AS 数量相加
FROM PO;

供参考

附   件:

点击下载此附件